lec:oracle:11gadmin1

차이

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

차이 보기로 링크

--- lec:oracle:11gadmin1 [2017/02/04 23:44] – [17] starlits
+++ lec:oracle:11gadmin1 [2017/02/05 00:52] (현재) – [17] starlits
@@ 줄 3: / 줄 3: @@
 ===== 17 =====
-| pre-work | SQL> create directory dpdata as '/home/oracle/dpdpata'; |
+| 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 | $ expdp hr/oracle directory=dpdata dumpfile=expdp_hr.dmp schemas=hr logfile=expdp_hr.log job_name=expdp_hr |
-| impdp |  |
+|  | 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.1486221260.txt.gz · 마지막으로 수정됨: 2017/02/04 23:44 저자 starlits