Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    12

    Unanswered: Oracle 8.1.7 Export from Solaris then Import into Win 2k.

    I am relatively new to oracle and I need to perform the operation mentioned above.

    I am trying to create a development copy of the database.

    any ideas or advice???

    thanks in advance

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    You assumption is right!

    Hi


    You can simply make an export on Solaris platform and import it on Windows 2000, no problem.

    Make sure that RDBMS versions are the same (or Windows 2000 database where your importing in is higher version than Solaris)

    Good luck!

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Mar 2003
    Posts
    12
    and how would I do that??

    i have never done an import or an export before.

    any ideas??

    thanks for the reply btw

    is its exp or something ?? i was reading it. bother versions are 8.1.7i

  4. #4
    Join Date
    Feb 2003
    Posts
    45

    Spoon feeding

    Hi Ken Doh,

    The clue that remivisser gave you is the word exporting or export.

    Bung this into Oracle's OTN or even a good search engine and you'll get loads of useful stuff back.

    A little bit of self learning/teaching can go a long way.

    Please only post back here if you are having REAL problems with the actual EXP command itself.....

  5. #5
    Join Date
    Mar 2003
    Posts
    12

    Smile

    indeed it can

    created a user
    created a table space owned by that user
    ran the imp command


    imported perfectly

Posting Permissions

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