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)