Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2007
    Posts
    7

    Question Unanswered: Oracle db to sql

    Hello,

    I made this oracle db for school (home computer Oracle Database 10g Express Edition)
    and I need to put some specified tables on our oracle test server of the school.
    Does anyone know of a way to get the create sql of all the tables I want.
    I have tried getting just the SQL from each table in the SQL tab of the tables.
    But that's not working cause I have made some contraints and other adjustments after creating the column.


    I hope you understand what I mean, and have a solution for my problem.

    Thanks in advance,

    Automic

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    You can use the built-in package DBMS_METADATA

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Didn't you save the scripts in file system? It is always a good idea to have something like that; you can never know when you'll need it.

    Besides Shammat's suggestion, you might EXPORT your local schema and IMPORT it into the school database. The simplest way is ... well, really simple:
    Code:
    HOME> exp username/password file=home_db.dmp
    
    SCHOOL> imp username/password file=home_db.dmp
    If you, however, need something more sophisticated, find it in the documentation.

  4. #4
    Join Date
    Sep 2007
    Posts
    7
    Many thanks for this information, it helped me alot!
    Problem solved

Posting Permissions

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