How complete is an Oracle11g IMPDP?

Question

I was given the task of upgrading to a new Oracle Database Server (11gR2). The former DBA gave these instructions:

Use Embarcadero to export Roles from Old and execute SQL on New Server

Use Embarcadero to export Tablespaces from Old and Execute SQL on New

Use Embarcadero to export Users from Old and Execute SQL on New

Use expdp/impdp to copy the schemas only out of the full dmp file

My question is "Couldn't I just use the full export to do everything at once?" The only thing I'm not 100% sure of is whether it will put all the tablespaces back to the same locations.

Thanks.

Answer 1

If you have a full export (i.e. you specified FULL=Y), it should contain the CREATE TABLESPACE commands that would recreate the tablespaces on the destination server with the same data files in the same directory structure as the source database. I'm not sure why the former DBA prefers to go through multiple steps rather than simply using impdp-- have you asked him or her why they don't simply use impdp?