DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle 10g to 9i

  1. 02-07-2008, 12:54 PM #1
    st2000
    st2000 is offline Senior Member
    Join Date
    Oct 2000
    Posts
    449

    Oracle 10g to 9i

    Hello DBAs:

    Due to application issues, we have to downgrade a 10g database to 9i.

    Can anyone let me know the possibilities and references and issues faced or experienced.

    Database currently is in 10.2.0.2
    Need to install a new oracle home in the same host with 9.2
    Import the dmp file

    Thanks
    Reply With Quote Reply With Quote
  2. 02-07-2008, 02:34 PM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    whats your COMPATIBLE parameter setting

    regards
    Hrishy
    Reply With Quote Reply With Quote
  3. 02-12-2008, 01:36 PM #3
    st2000
    st2000 is offline Senior Member
    Join Date
    Oct 2000
    Posts
    449
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    compatible string 10.2.0
    Reply With Quote Reply With Quote
  4. 02-12-2008, 05:08 PM #4
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Well it seems export import seems to be the only option now.

    regards
    Hrishy
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width