How complete is an Oracle11g IMPDP?
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 exp开发者_如何学运维ort 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.
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?
精彩评论