single line sql of exp

[sssdexter]

Hi,

How can write a single line script that exp a database table structure out witout copy the data? I would like to put that script in *.bat file, so that i can just doubleclick on that file, then it will auto generate all the table structures out.

Thanks in advance

 

[SantaMufasa]

Dexter,

Use the "rows=n" parameter: Your "exp" command can in the form:
exp tables=tab_name rows=n file=file_name userid=username/password

Depending upon your Oracle version, you may see a warning, "EXP-00091: Exporting questionable statistics.", but guess what...we don't care about statistics for a table with no rows, now do we?

Dave
Sandy, Utah, USA @ 09:30 GMT, 02:30 Mountain Time