2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
I got the answer here is the API that is to be run, for those into similar situation
DECLARE hdnl NUMBER; BEGIN hdnl := DBMS_DATAPUMP.OPEN(operation => 'IMPORT', job_mode => 'SCHEMA', job_name => null); DBMS_DATAPUMP.ADD_FILE(handle => hdnl, filename => 'dump.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file); DBMS_DATAPUMP.ADD_FILE(handle => hdnl, filename => 'imp.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file); DBMS_DATAPUMP.metadata_remap(handle => hdnl, name => 'REMAP_SCHEMA', old_value => 'TEST', value => 'TEST_COPY'); DBMS_DATAPUMP.START_JOB(hdnl); END; /
답변함 10달 전
0
I am trying to import a schema but I want to remap it to a different schema
답변함 10달 전
관련 콘텐츠
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 3년 전