lec:oracle:11gadmin1
문서의 이전 판입니다!
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 hr/oracle directory=dpdata dumpfile=expdp_hr.dmp content=all tables=“MEMBER” REMAP_TABLE = 'MEMBER':'MEMBER2' logfile=impdp_hr_member2.log job_name=impdp_hr_member2 |
|
| sqlldr |
lec/oracle/11gadmin1.1486223260.txt.gz · 마지막으로 수정됨: 저자 starlits