export table ddl to a separate file

[coolmandba]

Hi all,

Does anyone know how to export table ddl including tablespaces info, space info, etc to separate files individually.
ie. each table -> one file?
Thanks.

[sreddy]

You have to use SHOW=Y option while exporting and you get the DDL of INDEXES,TABLES into one log file. Go ahead and edit the logfile and cut, copy to sinfle text file. thats the only way you can do it from export. Not sure there might/will be third party tolls makes your life little easier.

[url]http://dbasupport.com/forums/showthread.php?threadid=7103[/url]
[url]http://dbasupport.com/forums/showthread.php?threadid=5640[/url]
[url]http://dbasupport.com/forums/showthread.php?threadid=5430[/url]