Home » RDBMS Server » Server Utilities » DBMS_DATAPUMP.metadata_filter + long table list (10g oracle)
DBMS_DATAPUMP.metadata_filter + long table list [message #459989] Wed, 09 June 2010 05:20 Go to next message
sanju_chenna
Messages: 5
Registered: June 2010
Junior Member
Hi all,
I have a problem with DBMS_DATAPUMP.metadata_filter.

Let's suppose that I need to export a huge list of tables (a,b,c,d,e,f,g,h,i...). Let's suppose that the list is dynamic

I do NOT want to use

DBMS_DATAPUMP.metadata_filter (handle => h1,
NAME => 'NAME_EXPR',
VALUE => 'IN (''a'', ''b'', ...)',
object_type => NULL);


In my_export_table there is the list:

CREATE TABLE my_export_table
(
EXPORT_OBJECT_NAME VARCHAR2(50 BYTE)
)

Now I'm trying to use this form:

DBMS_DATAPUMP.metadata_filter (handle => h1,
NAME => 'NAME_EXPR',
VALUE => 'IN (SELECT a.export_object_name FROM my_export_table a, user_objects b WHERE a.export_object_name = b.object_name AND b.object_type = ''TABLE'')',
object_type => NULL
);

but it results in error.

Any idea for helping me?

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1891
ORA-06512: at "SYS.DBMS_METADATA", line 3878

Re: DBMS_DATAPUMP.metadata_filter + long table list [message #460088 is a reply to message #459989] Wed, 09 June 2010 09:29 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Any idea for helping me?
datapump has an API
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_api.htm#i1008009
Previous Topic: Recovery Problem
Next Topic: URGENT:-XDB Schema
Goto Forum:
  


Current Time: Tue Sep 28 19:53:50 CDT 2021