Home » RDBMS Server » Server Utilities » List of tables in export (Oracle 10g,Solaris)
List of tables in export [message #362033] Sun, 30 November 2008 01:17 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Hi all,

I want to export some 100 tables from a schema.I cannot keep mentioning all the 100 tables in the export command like ( tables=t1,t2,t3..)which is a time consuming factor. Is there any other way that i can export it in a simple way??

Can anybody come up with the solution??

Thanks in advance,
Balaji
Re: List of tables in export [message #362036 is a reply to message #362033] Sun, 30 November 2008 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
Whatever is the solution, you have to list the 100 tables otherwise Oracle can't know which one you want to export.

Regards
Michel
Re: List of tables in export [message #362043 is a reply to message #362036] Sun, 30 November 2008 03:26 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks for your information michel.
Previous Topic: conditional loading into nested tables
Next Topic: Not able to load data to the table using SQL Loader utility
Goto Forum:
  


Current Time: Fri Dec 09 02:02:33 CST 2016

Total time taken to generate the page: 0.07367 seconds