OraFAQ Forum: Server Utilities » List of tables in export

Home » RDBMS Server » Server Utilities » List of tables in export (Oracle 10g,Solaris)

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

List of tables in export [message #362033]

Sun, 30 November 2008 01:17

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

Report message to a moderator

Re: List of tables in export [message #362036 is a reply to message #362033]

Sun, 30 November 2008 01:48

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: List of tables in export [message #362043 is a reply to message #362036]

Sun, 30 November 2008 03:26

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Thanks for your information michel.

Report message to a moderator

Previous Topic:	conditional loading into nested tables
Next Topic:	Not able to load data to the table using SQL Loader utility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:55:42 CST 2024