OraFAQ Forum: Server Utilities » Dynamic schema and tables name in dbms

Home » RDBMS Server » Server Utilities » Dynamic schema and tables name in dbms_datapump (oracle 10.2.0.4.0 on linux.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dynamic schema and tables name in dbms_datapump [message #416821]

Tue, 04 August 2009 07:57

Rijesh
Messages: 6
Registered: November 1998

Junior Member

Hi,

I recently started using the dbms_datapump package for export and import.
I would like to know if the parameters like the schema name and tables can be made dynamic.
In a nutshell, can we use somethign like this

DBMS_DATAPUMP.METADATA_FILTER(h1,'SCHEMA_EXPR','IN (''v_schema_name'')');

Appreciate a reply

Thanks

Rij

Report message to a moderator

Re: Dynamic schema and tables name in dbms_datapump [message #416861 is a reply to message #416821]

Tue, 04 August 2009 17:01

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>I would like to know if the parameters like the schema name and tables can be made dynamic.

Please explain more details.

Report message to a moderator

Re: Dynamic schema and tables name in dbms_datapump [message #416863 is a reply to message #416821]

Tue, 04 August 2009 17:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I would like to know if the parameters like the schema name and tables can be made dynamic.

When all else fails, Read The Fine Manual
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_datpmp.htm#i1007277

Report message to a moderator

Previous Topic:	export on two destination
Next Topic:	Load mutiple tables using SQL loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 10:48:46 CDT 2024