troubleshooting Question

schema level export or expdb in oracle

Avatar of pavan27
pavan27Flag for United States of America asked on
Oracle Database
4 Comments1 Solution2965 ViewsLast Modified:

i need some information regarding export /expdp at schema level.  let me explain the senerio.

i have one database. in that i need to take export/expdp of one schema. after taking the export /expdp i have to drop the database.
after droping the database i need to refresh the database from production. upon completion of refresh from prod i have to import the export/expdp dump file in the newly refreshed database. can any one suggest me work around on this.

while taking export or expdp what are the considerations i have to take care.
while importing the dump file on newly created database , do i get any path problems like(dbf path/ control file path/ redolog file path)
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros