export table ddl to a separate file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export table ddl to a separate file

  1. #1
    Join Date
    Dec 2000
    Posts
    87
    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.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  



Click Here to Expand Forum to Full Width