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

Thread: content of exported file

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    generate schema script

    Hi,

    When I look at the content of an exported file, it contains a header followed by basically bunch of SQL statements.

    If I have an existing database but don't have the scripts to recreate schema (including constraints, etc.), the best way to generate a script for the schema is to extract from the content of the exported file? Is it a reliable way?

    Is there a better way to generate a script for the schema in an existing DB?

    Thanks,
    Last edited by a128; 12-05-2002 at 08:14 PM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi

    Just do a simple import with rows=n, that way u will get all ur schemas (users,tables,indexes,views,constraints,procedures,packages,triggers etc) excluding data.

    Regards
    Amar

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    If you want to create a set of schema build scripts take a look at the free datatool at http://www.databee.com

    If you follow Amar's advice the datatool above reads the exprt file and produces the schema defintion.

    It's quite neat and save a lot of time.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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