Error while importing into oracle 10.1 using 10.2 Client
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Error while importing into oracle 10.1 using 10.2 Client

Hybrid View

  1. #1
    Join Date
    Sep 2005
    Posts
    46

    Error while importing into oracle 10.1 using 10.2 Client

    Hai every body,
    I have a client db dump taken from oracle 10.2 DB using a 10.2 client. But what I have is 10.1 DB. While importing I got errors. Hence i installed a 10.2 client and tried importing into 10.1 using the 10.2 client. But then i got the following error.

    IMP-00058: ORACLE error 6550 encountered
    ORA-06550: line 1, column 33:
    PLS-00302: component 'SET_NO_OUTLINES' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    IMP-00000: Import terminated unsuccessfully
    Since its a client DB, i cannot ask for exporting again. Is there any way to solve this issue. I mean, i need to import a 10.2 dump into a 10.1 DB either using 10.1 client or 10.2 client.


    regards
    Issac

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    It is not supported to import a dump from later version into earlier, so that is not a surprise.
    Maybe you can connect to 10.2 with 10.1 exp and try exporting with 10.1 client

    Regards

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Issac, You might want to check Metalink Note:132904.1 -Compatibility Matrix for Export & Import Between Different Oracle Versions
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

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



Click Here to Expand Forum to Full Width