DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export table ddl to a separate file

  1. 03-14-2001, 04:39 PM #1
    coolmandba
    coolmandba is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 03-14-2001, 05:40 PM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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