lec:oracle:11gadmin1
차이
문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판
이전 판
|
다음 판
양쪽 다음 판
|
lec:oracle:11gadmin1 [2017/02/05 00:26] starlits [17] |
lec:oracle:11gadmin1 [2017/02/05 00:31] 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 system/oracle directory=dpdata dumpfile=hr.dmp schemas=hr logfile=hr.dmp.log job_name=expdp_hr | | | | expdp | $ expdp system/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 | |
| | sqlldr | | | | | sqlldr | | |
| |
lec/oracle/11gadmin1.txt · 마지막으로 수정됨: 2017/02/05 01:22 저자 starlits