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

Thread: DDL script

  1. #1
    Join Date
    Mar 2002
    Posts
    303

    DDL script

    How can i generate a DDL script for a schema.
    I have Toad and i hav'nt a change manager.

    Thank's

  2. #2
    Join Date
    Dec 2001
    Posts
    120
    in toad u have this option under database->export->table scripts.Select whichever schema u want from the drop down list and then select the tables from the bottom text area. Rest of it is very simple.

    hope this solves ur problem

  3. #3
    Join Date
    Mar 2002
    Posts
    303
    Thank's it's help

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    But don't forget to check the DDL script generated using TOAD, I had problems in foreign key constraints.. It was version 7.1, I just checked in my latest version and now it look fine..

    Sameer

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