Oracle DataBase 11g Admin I 강의

17

8 pre-work SQL> create directory dpdata as '/home/oracle/dpdpata';
SQL> GRANT READ ON DIRECTORY dpdata to hr ;
SQL> GRANT WRITE ON DIRECTORY dpdata to hr;
expdp $ expdp hr/oracle directory=dpdata dumpfile=expdp_hr.dmp schemas=hr logfile=expdp_hr.log job_name=expdp_hr
impdp $ impdp system/oracle directory=dpdata dumpfile=expdp_hr.dmp schemas=hr logfile=impdp_hr.log job_name=impdp_hr
$ impdp system/oracle directory=dpdata dumpfile=expdp_hr.dmp tables=“HR.MEMBER” REMAP_TABLE = 'MEMBER':'MEMBER2' logfile=impdp_hr_member2.log job_name=impdp_hr_member2
sqlldr
exp / imp $ exp userid=system/oracle owner=scott file=exp_scott.dmp