Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2013

    Unanswered: Oracle Data Load ( to (

    Hello All Gurus,

    I have a situation so just wanted to know if it is poosible to load the data from Oracle version ( to (
    My current production system is on Oracle and my new production system is on (since solaris 10 supports this). So if i have to load the data from Old to New Production Server, will it be poosible even though there is a mismatch in Oracle versions?

    Thanks in advance!!!

    Ankur Pachauri

  2. #2
    Join Date
    Feb 2006
    Provided Answers: 1
    One way is to use Oracles export and import utilities:
    Oracle Export and Import utility tutorial | ORA Training Blog

  3. #3
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    No problem with export/import, as far as I can tell. You don't have to worry about version mismatch - it is still 9.2.

    Besides, Oracle is capable of moving data between different (major) versions, for example you could export data from your 9.2. and import it into 10.2.

    Generally speaking, export should be done with a EXP utility of the lowest version involved, while import should be done with a IMP utility of the target database.

    Here's some more information (including EXP - IMP version matrix).

Posting Permissions

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