사용자 도구

사이트 도구


lec:oracle:11gadmin1

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

양쪽 이전 판 이전 판
다음 판
이전 판
lec:oracle:11gadmin1 [2017/02/05 00:47]
starlits [17]
lec:oracle:11gadmin1 [2017/02/05 01:22] (현재)
starlits [17]
줄 5: 줄 5:
 | 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