Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: Oracle SQL Developer

    Anyone know how to gen DDL out of this "tool"

    my ERWin version only goes up to 8i I think and I need to get the DDL and Relationships into a model
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    command line way is via procedure

    DBMS_METADATA.GET_DDL
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Got it

    Tools>Database Export

    Kinda misleading...gotta be careful not to export the data as well

    It's just a small check box on one of the GUI Panels

    SQL Server would have been

    Right Click on the DB > Tasks > Generate Scripts

    Not Export Database

    Thanks...you guys are a big help
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by anacedent
    command line way is via procedure

    DBMS_METADATA.GET_DDL

    Thanks a bunch

    sqlcmd DBMS_METADATA.GET_DDL

    Is that the syntax?

    Or do I need to put into a script file, the call it with

    sqlcmd -s....ect
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    GET_DDL is a PL/SQL function call.

    Code:
    FUNCTION GET_DDL RETURNS CLOB
     Argument Name                  Type                    In/Out Default?
     ------------------------------ ----------------------- ------ --------
     OBJECT_TYPE                    VARCHAR2                IN    
     NAME                           VARCHAR2                IN    
     SCHEMA                         VARCHAR2                IN     DEFAULT
     VERSION                        VARCHAR2                IN     DEFAULT
     MODEL                          VARCHAR2                IN     DEFAULT
     TRANSFORM                      VARCHAR2                IN     DEFAULT
    GOOGLE/SEARCH DBMS_METADATA
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by Brett Kaiser
    Is that the syntax?

    Or do I need to put into a script file, the call it with

    sqlcmd -s....ect
    Are you sure you are using Oracle?
    The command line interface for Oracle is called sqlplus not sqlcmd (sqlcmd is for SQL Server)

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    expdp content=metadata_only
    impdp sqlfile=ddl.sql
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by shammat
    Are you sure you are using Oracle?
    The command line interface for Oracle is called sqlplus not sqlcmd (sqlcmd is for SQL Server)

    Hey thanks

    That was helpfiul

    so, anyone have the actual command line syntrax?

    sqlplus -s...(maybe) Server pwd login?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by Brett Kaiser
    so, anyone have the actual command line syntrax?

    sqlplus -s...(maybe) Server pwd login?
    SQL*Plus User's Guide and Reference -- Contents

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well THAT's got BOL beat hands down
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  11. #11
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    I posted the link to the 9i documentation because the server for the current version(s) was down yesterday.

    Oracle 11g manuals: Oracle Database Online Documentation 11g Release 1 (11.1)
    Oracle 10g manuals: Oracle Database Online Documentation 10g Release 2 (10.2)

Posting Permissions

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