Home » RDBMS Server » Server Utilities » Initiate Expdp/impdp from oracle procedure. (oracle 10g on linux)
Initiate Expdp/impdp from oracle procedure. [message #643470] Thu, 08 October 2015 04:02 Go to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi All,

For some reasons, I want to make a process by which we can export table based on specific condition and import the same tables from dump-file given. Problem is the number of tables is very high (more than 350 out of 500) and the tables selection criteria for the tables is time based.

for this I want to execute expdp and impdp from procedure.

So please tell me if any one faced/solve this issue.

Thanks in Advance.
Pradeep


Re: Initiate Expdp/impdp from oracle procedure. [message #643473 is a reply to message #643470] Thu, 08 October 2015 04:25 Go to previous message
John Watson
Messages: 8297
Registered: January 2010
Location: Global Village
Senior Member
Quote:
for this I want to execute expdp and impdp from procedure.

http://docs.oracle.com/database/121/SUTIL/GUID-EAD7AE4B-778A-4369-9842-68E026409045.htm
Previous Topic: SQLLDR
Next Topic: Multiple Export Dump File generation using %u.
Goto Forum:
  


Current Time: Tue Jul 14 09:22:09 CDT 2020