Hi all,
I have to export a schema from one database and import it into a different newly created database using expdp.
For this, i have exported the schema using these commands..
expdp system/xxxxxxx schemas=accounts dumpfile=accounts%U.dmp directory=exp logfile=schema_accounts.log parallel=5
This schema resides on tablespace Accounts.
However in the new database i have to import this into a new schema named Finance. I have created a new tablespace named Finance here in the new db, and sized it appropriately.
I was reading the oracle documents, and there i read i am supposed to use the remap_schema=accounts:finance command.
So here is a question, am i supposed to use this in the expdp also? or just impdp? I have already exported the schema but if i have to re-do it with the remap_schema again i will do it.
Also, do i need to use remap_datafiles and remap_tablespace as well? or its not required in my scenario.
Please guide.