How to install

How to Backup with Export / Import

— Create a directory
CREATE OR REPLACE DIRECTORY test_dir AS ‘/home/backup/exports/’;

— create an export full database and a schema
expdp system/password full=Y directory=TEST_DIR dumpfile=test2.dmp
logfile=test2.log=
expdp system/password schemas=user2 directory=TEST_DIR
dumpfile=test3.dmp logfile=test3.log

— imports
impdp system/password full=Y directory=TEST_DIR dumpfile=test2.dmp
logfile=test2.log=
impdp system/password schemas=user2 directory=TEST_DIR
dumpfile=test3.dmp logfile=test3.log

Subscribe to our newsletter

Follow Us

Read More…

Comments are closed.