DDL generate script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DDL generate script

  1. #1
    Join Date
    Aug 2000
    Posts
    87

    DDL generate script

    Hi All,

    Can anyone provide a script which could generate "create" DDL script for tables & indexes in a schema.I have one which can handle with non partition tables and indexes.I need now for both partition tables & indexes(LOCAL) with storage clause as well.

    Thanks in advance.
    Regards,
    Vinod

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

  3. #3
    Join Date
    Aug 2002
    Posts
    35
    which version of oracle r u using
    if its 9i try this ... u might neet to set long to a big value
    like
    set long 100000

    Select dbms_metadata.get_ddl('TABLE',TABLE_NAME)
    from
    user_tables
    where
    nested = 'NO'
    "Be not afraid of growing slowly. Be afraid only of standing still."

  4. #4
    Join Date
    Aug 2000
    Posts
    87
    Guys thanks for your replies.
    I am using 8.1.7 version.Databee doesnt work...its crashes with illigal operation when i start after download.

    any other ?
    regards,
    Vinod

  5. #5
    Join Date
    Feb 2001
    Posts
    203
    Try DBArtisan, You will get 15days or 1 months free.

    http://www.embarcadero.com/products/dbartisan/index.asp

    By using this you can generate all objects info in html format also.

    Good Luck.

    Sree.
    sree

  6. #6
    Join Date
    Aug 2002
    Posts
    35
    try these scripts
    i guess this should help
    Attached Files Attached Files
    "Be not afraid of growing slowly. Be afraid only of standing still."

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