lec:oracle:11gadmin1
차이
문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판
이전 판
다음 판
|
이전 판
|
lec:oracle:11gadmin1 [2017/02/05 00:47] starlits [17] |
lec:oracle:11gadmin1 [2017/02/05 01:22] (현재) starlits [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; | | | 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 | | | | 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 | | | | 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 | | | | | sqlldr | | |
| | | exp / imp | $ exp userid=system/oracle owner=scott file=exp_scott.dmp | |
| |
lec/oracle/11gadmin1.1486223260.txt.gz · 마지막으로 수정됨: 2017/02/05 00:47 저자 starlits