Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    india,hyderabad
    Posts
    43

    Unanswered: re: extracting ddl

    hi! guys ,

    Can anybody help me out ...??

    I am trying to extract ddl of a schema...
    My oracle version is 8.1.7 ..

    Can anybody send a script || post a script || point out
    to a link where I can get such a script ....

    I do not have the T.O.A.D option

    thanks
    harry

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink

    Try this:

    exp <uid>/<pw> owner=<schema> rows=N

    then,

    imp <uid>/<pw> fromuser=<schema> indexfile=schema.sql

    Also checkout: http://www.databee.com/main.htm (FREE )


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    You can also use the Oracle 9i DBMS_METADATA package. Example is posted here

    HTH,

    clio_usa - OCP 8/8i/9i DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •