-
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.
-
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]
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|