Search This Blog

Tuesday, March 13, 2012

schema export/import using datapump (schema names and tablespace names are same)

check the schema size

check whether you have enough space in the filesystem in which you are going to perform the export

export parameters
------------------------
schemas, directory, logfile, dumpfile

transfer the dump file using scp from source to the destination database
make sure the files have the 700 privilege

drop and create the schema in the destination database

make sure whether you have sufficient space in the database and in the filesystem

import parameters
-------------------------
schemas, directory, logfile, dumpfile

No comments:

Post a Comment