Home » RDBMS Server » Server Utilities » Dynamic schema and tables name in dbms_datapump (oracle 10.2.0.4.0 on linux.)
Dynamic schema and tables name in dbms_datapump [message #416821] Tue, 04 August 2009 07:57 Go to next message
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
Re: Dynamic schema and tables name in dbms_datapump [message #416861 is a reply to message #416821] Tue, 04 August 2009 17:01 Go to previous messageGo to next message
babuknb
Messages: 1734
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.
Re: Dynamic schema and tables name in dbms_datapump [message #416863 is a reply to message #416821] Tue, 04 August 2009 17:29 Go to previous message
BlackSwan
Messages: 25042
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
Previous Topic: export on two destination
Next Topic: Load mutiple tables using SQL loader
Goto Forum:
  


Current Time: Wed Dec 07 06:36:18 CST 2016

Total time taken to generate the page: 0.17569 seconds