Montag, 14. Juli 2008

IMP and EXP with data pump

$ expdp hr/hr DIRECTORY=exp_dir DUMPFILE=hr_exp.dmp LOGFILE=hr_exp.log

$ CREATE DIRECTORY dir_dump AS 'D:/tmp'

create user hr2

$ GRANT READ, WRITE ON DIRECTORY dir_dump TO hr2

$ impdp hr2/hr2 SCHEMAS=hr2 DIRECTORY=dir_dump LOGFILE=hr2_imp.log DUMPFILE=hr_exp.dmp

Keine Kommentare: