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

Thread: schema scripts

  1. #1
    Join Date
    Feb 2001
    Posts
    107

    Cool

    Does anyone have any scripts to capture a database schema?


    Thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Have a look at this tool. It's pretty neat and useful.

    http://www.databee.com/dt_home.htm

    Sanjay

  3. #3
    Join Date
    Feb 2001
    Posts
    107
    Thanks Sanjay

  4. #4
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    cool that been something on my wants list for a while (just never got round to sorting it out).

    cheers

  5. #5
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Thanks a lot
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  6. #6
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    If you're using Oracle9i you can get the information using the DBMS_METADATA package:

    http://www.oracle-base.com/Articles/9i/MetadataAPI.asp

    You could do something like:

    SET PAGESIZE 0
    SET LONG 10000
    SPOOL c:\MY_SCHEMA.sql

    SELECT dbms_meatdata(object_type, object_name, owner)
    FROM dba_objects
    WHERE owner = 'MY_SCHEMA'
    ORDER BY object_type;

    SPOOL OFF
    SET PAGESIZE 18

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

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