Hello,
Env; Oracle 11gR2 (11.2.0.3.6) on OL 6.2 64bit on filesystem
I have on existing PROD database.
I have created another empty database just like the prod and I have created all the tablespaces that exist in the PROD database.
Now I have been asked to take a full export of the PROD database and import into this new database.
I plan to use expdp and impdp. This will be first time when I'll attempt to import a full expdp export. Is there anything I need to do before attempting the import? Do I need to create anything other than the tablespaces? I want to exclude oracle's internal schems during impdp - hope that EXCLUDE will help me do this.
I have noticed that in the PROD databases there are many ROLEs. I hope these roles will be brought over during impdp.
I also notice that there are grans to schema-a on objects of schema-b (impdp may import schema-a first and schema-b later). Will the impdp handle this automatically?
Please advise.
Thanks in advance
Best regards