Results 1 to 12 of 12
  1. #1
    Join Date
    Mar 2004
    Posts
    17

    Question Unanswered: Exporting schema oracle 8i

    I am migrating oracle 8i to Linux.

    Does anyone know if there is a way to export the schema, all the tables rather than recreating them in the Linux box.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    owner=schema_name


    at commandline type:
    exp help=y
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Mar 2004
    Posts
    17
    Originally posted by The_Duck
    owner=schema_name


    at commandline type:
    exp help=y
    I think I asked the question wrong. I want to export all the table names and properties.

    thanks

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    I don't think you read the docs on this command ...
    Code:
    http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1013411
    with the defaults and the owner specified you should be all set.
    Have you tested it?

    If this is not what you are referring to then please be more specific.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > I want to export all the table names and properties
    ROWS=NO

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    bah!

    import rows=N
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Mar 2004
    Posts
    17
    I am sorry I should have been more specific.
    The thing is I have that database left here from the administrator before, but I have little knowledge of Oracle.

    My task is to migrate that database to Linux(it is on win 2000 now)

    I ve been researching and as far as know so far, the way to export it is to export the data, then create all the tables in the new database, and then import all the data.

    My question is - is there a way to automate the creation of the tables, I mean to automatically generate a script, that I could use to crete all the tables. Or maybe there is another way to do it.

    Thank again for any replies

  8. #8
    Join Date
    Mar 2004
    Posts
    17
    I think my question is - would I have to anything else rather than export on the Win 2000 box and Import on the Linux box??

  9. #9
    Join Date
    Mar 2004
    Posts
    14
    Why you don't belive The_Duck - it's seem to me too that use exp and imp utilities is most easy way to transfer everything from one databese to other. You will have *.dat file with all nessessary info

  10. #10
    Join Date
    Mar 2004
    Posts
    17
    Originally posted by andrev
    Why you don't belive The_Duck - it's seem to me too that use exp and imp utilities is most easy way to transfer everything from one databese to other. You will have *.dat file with all nessessary info
    It's not that I don't believe him. I just want to make sure that's all I will have to do.

  11. #11
    Join Date
    Mar 2004
    Posts
    14
    The best way - just try to use exp and imp - it's easy and you will see it it method is good for you - they are really powerful

    or ( oracle 9i ) read this about dbms_metadata
    http://www.dba-oracle.com/art_builde...ema_syntax.htm
    may be this will help

  12. #12
    Join Date
    Jul 2003
    Posts
    2,296
    he doesn't believe me ...

    woe to the Duck!

    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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