Home » SQL & PL/SQL » SQL & PL/SQL » Export -Import (Oracle10g)
Export -Import [message #399046] Mon, 20 April 2009 06:19 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi,
Can we do Export- Import using Oracle Procedure/Function.
Re: Export -Import [message #399048 is a reply to message #399046] Mon, 20 April 2009 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, not directly.

Regards
Michel
Re: Export -Import [message #399062 is a reply to message #399048] Mon, 20 April 2009 07:17 Go to previous messageGo to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

IF We have to execute using Pl/SQL then how to do it?
Re: Export -Import [message #399064 is a reply to message #399062] Mon, 20 April 2009 07:19 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


NO; you can't
Re: Export -Import [message #399065 is a reply to message #399062] Mon, 20 April 2009 07:21 Go to previous message
bonker
Messages: 402
Registered: July 2005
Senior Member
If you are in Oracle 10G then you can use Oracle Datapump. It has PLSQL api's as well.

Read this for some examples on it http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
Previous Topic: help in sql (merged 3)
Next Topic: dbms_job slight bug?
Goto Forum:
  


Current Time: Fri Dec 09 07:42:14 CST 2016

Total time taken to generate the page: 0.09551 seconds