Home » RDBMS Server » Server Utilities » DBMS_DATAPUMP - EXPORT, TRANSPORTABLE - missing info (10.2.0.4, Red Hat Linux 64)
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

Previous Topic: Export Full DB with no Tablespace
Next Topic: Export using Batch but hiding cmd prompt
Goto Forum:
  


Current Time: Fri Mar 29 06:16:08 CDT 2024