Home » RDBMS Server » Server Utilities » Exporting table structure from a particular DB
icon4.gif  Exporting table structure from a particular DB [message #482080] Tue, 09 November 2010 07:40 Go to next message
Messages: 10
Registered: July 2009
Location: Chennai
Junior Member

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
Re: Exporting table structure from a particular DB [message #482081 is a reply to message #482080] Tue, 09 November 2010 07:42 Go to previous message
Messages: 21811
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
Previous Topic: Import Mistakes ....
Next Topic: append tables content to an existing tables
Goto Forum:

Current Time: Fri May 24 05:00:08 CDT 2024