| DBMS_DATAPUMP - EXPORT, TRANSPORTABLE - missing info [message #397938] |
Tue, 14 April 2009 11:21 |
alexdba
Messages: 1
Registered: April 2009
|
Junior Member |
|
|
Hello everyone,
For two days I am struggling with my problem.
The issue is that I am trying to do export trasportable using DBMS_DATAPUMP.
When I am using DBMS_DATAPUMP in my log I see
#################################################
Starting "DBA_GRP"."EXP_JOB11":
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "DBA_GRP"."EXP_JOB11" successfully loaded/unloaded
#############################################
When I am using
expdp dba_grp/pasw_grp@TST DUMPFILE=tablespacename200812_alex.dmp DIRECTORY=trans_dir TRANSPORT_TABLESPACES=tablespacename200812
in the log file I see
#########################################################
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
######################################################
Because DBMS_DATAPUMP misses
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK and
Processing object type TRANSPORTABLE_EXPORT/TABLE
I am not able to import the transportabe tablespace back to the database.
I have googled, in ask tom, oracle forum and many other web-sites, but was not able to resolve my problem.
Could you please have a look my code?
I believe the issue is in steps: STEP 4 or STEP 4-1 but I am not sure. I may missing another parameter or so.
Thank you very much for your help in advance!
BEGIN
v_dp_num := DBMS_DATAPUMP.OPEN('EXPORT', 'TRANSPORTABLE',NULL,'EXP_JOB11');
DBMS_OUTPUT.put_line('STEP 1 done: job handle no is ' || v_dp_num);
DBMS_DATAPUMP.add_file(handle => v_dp_num,
filename => rec.tablespace_name || '.metadata.log',
DIRECTORY => 'TAB_PART_ARCH',
filetype => DBMS_DATAPUMP.ku$_file_type_log_file
);
DBMS_OUTPUT.put_line('STEP 2 done');
DBMS_DATAPUMP.add_file(handle => v_dp_num,
filename => rec.tablespace_name || '.metadata.dmp',
DIRECTORY => 'TAB_PART_ARCH',
filetype => DBMS_DATAPUMP.ku$_file_type_dump_file
);
DBMS_OUTPUT.put_line('STEP 3 done');
DBMS_DATAPUMP.set_parameter(handle => v_dp_num,
name=>'TTS_FULL_CHECK',
value=>1
);
DBMS_OUTPUT.put_line('STEP 4 done');
DBMS_DATAPUMP.metadata_filter(Handle => v_dp_num,
Name => 'TABLESPACE_EXPR',
value => 'IN (''%tablespacename200812%'')'
);
DBMS_OUTPUT.put_line('STEP 4-1 done');
DBMS_DATAPUMP.metadata_filter(Handle => v_dp_num,
Name => 'TABLESPACE_LIST',
value => '''tablespacename200812'''
);
DBMS_OUTPUT.put_line('STEP 5 done');
DBMS_DATAPUMP.start_job(v_dp_num);
EXCEPTION
WHEN OTHERS
THEN
v_sqlerrm := SQLERRM;
sp_log('METADATA FILE CREATION FAILED FOR ' || rec.tablespace_name || ' reason: ' || v_sqlerrm);
DBMS_DATAPUMP.stop_job(v_dp_num);
END;
[Updated on: Tue, 14 April 2009 11:35] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
