Results 1 to 8 of 8

Thread: Create Dump?

  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: Create Dump?

    hi there,

    I have to port a lot of tables from one oracle8 database to mysql. the oracledb though is located at a client, that is hosting our data, and will not give access to its hardware.

    I will get csv- or xml-dumps but since there are a lot of referencial keys in there, I want to have a dump without data but with all create statements including foreign keys an the like. they say, this would not be possible, since they don't have the enterprise manager, but if I could provide information on how to achieve this dump via (pl)sql, they would do it.

    is there a possibility to dump such information?

    regards
    /christian

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    There are plenty of tools to export a schema creation script such as SqlTools, TOAD etc or you can 'roll your own'.

    The problem will be getting them in a syntax which mySql supports.

    Hth
    Bill

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    no that will not be the problem.
    I just want to read the oracle schemes, to understand the tablestructures and then write an importfilter for our new application.

    just the statement please. ;-)

    regards
    /christian

  4. #4
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    There is no such single statement....

    do you want to include triggers, procs/funs/packages, sequences, tables, indexes, storage parameters, synonyms, grants etc etc

    There are some scripts on orafaq.com (http://www.orafaq.com/faqscrpt.htm#OBJMAN) which you will probably have to modify to suit exactly what you require.

    The following produce tools which can also do what you require....
    www.databee.com
    www.sqltools.net
    www.quest.com

    Hth
    Bill

  5. #5
    Join Date
    Sep 2003
    Posts
    4
    this seems very helpful, thanks a lot!
    /christian

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Originally posted by caefer
    no that will not be the problem.
    I just want to read the oracle schemes, to understand the tablestructures and then write an importfilter for our new application.

    just the statement please. ;-)

    regards
    /christian
    DBMS_METADATA extracts either SQL or XML for requested object(s).

  7. #7
    Join Date
    Sep 2003
    Posts
    4
    how can I do that?
    since I cannot operate such task on that database, I have to provide a working failsafe solution.
    to metion my needs: I need the create statement of every table (could be done one by one also) including all indecies and foreign keys. triggers and the like can be ignored.

    I need something like 'go there, click here, enter "..." '

    regards
    /christian

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Originally posted by caefer
    how can I do that?
    since I cannot operate such task on that database, I have to provide a working failsafe solution.
    to metion my needs: I need the create statement of every table (could be done one by one also) including all indecies and foreign keys. triggers and the like can be ignored.

    I need something like 'go there, click here, enter "..." '

    regards
    /christian
    Since I'm NOT being paid to do your job, I'm not going to spend
    much time trying to give you a clue or two. I would use the approach
    of SQL writing SQL.

    spool driver.sql
    SELECT 'EXEC DBMS_METADATA.GET_DDL(''TABLE'',' || TABLE_NAME ||
    || ');' FROM DBA_TABLES;
    @DRIVER.SQL
    EXIT

    I do conceed that the syntax above is NOT 100% correct,
    but hopefully this points you the right direction so you can find
    a solution that works for you.

    HAND!

Posting Permissions

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