impdp1 oracle / expdp / impdp - 디렉토리 조회 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 2020. 4. 17. 이전 1 다음 반응형