OraFAQ Forum: Server Utilities » Exporting table structure from a particular DB

Home » RDBMS Server » Server Utilities » Exporting table structure from a particular DB

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

Exporting table structure from a particular DB [message #482080]

Tue, 09 November 2010 07:40

veemani
Messages: 10
Registered: July 2009
Location: Chennai

Junior Member

Hi,

Can anyone help me to know the process of exporting only the table structure of a Database without the actual content of it.

Note:: I don't know how many tables are present in the DB.

Thanks & Regards,
Manikandan V

Report message to a moderator

Re: Exporting table structure from a particular DB [message #482081 is a reply to message #482080]

Tue, 09 November 2010 07:42

Littlefoot
Messages: 21781
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use ROWS=N parameter of the EXP utility. Something like

exp scott/tiger@ora10 rows=n file=scott.dmp

Report message to a moderator

Previous Topic:	Import Mistakes ....
Next Topic:	append tables content to an existing tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 05:47:44 CDT 2023