- 디렉토리 조회
sql> SELECT * FROM dba_directories;
- expdp 사용법
expdp system/비밀번호 schemas=유저명1 DUMPFILE=DUMPDIR:유저명1_201805281555.dmp logfile=DUMPDIR:유저명1_201805281555.log
impdp system/유저명2 DUMPFILE=DUMPDIR:유저명2_201805281555.dmp logfile=DUMPDIR:유저명2_201805281555.log REMAP_SCHEMA=유저명1:유저명2 REMAP_TABLESPACE=XXXX_DATA_TBL:TTTT_data_tbl
'DB > oracle' 카테고리의 다른 글
| CentOS6.5 / Oracle11g / The listener supports no services (0) | 2020.04.24 |
|---|---|
| oracle / random YYYYMMDD (0) | 2020.04.22 |
| oracle / job / batch (0) | 2020.04.17 |
| oracle / dbms_scheduler (0) | 2020.04.17 |
| oracle / 암호화 대상칼럼조회 (0) | 2020.04.17 |