OraFAQ Forum: Server Administration » Curses -- need my 10.2 DB backward compatible with 9.2

Home » RDBMS Server » Server Administration » Curses -- need my 10.2 DB backward compatible with 9.2 (10gR2, RHEL 64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Curses -- need my 10.2 DB backward compatible with 9.2 [message #298798]

Thu, 07 February 2008 14:32

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

I have a 10.2.0.3.0 Oracle database that needs to be compatible with 9.2.0.1.0 (for hp Openview). Problem is that the "compatible" parameter is set for 10.2.0.1.0, and -- according to metalink -- "export" and "import" are the only options left.

Two questions: (1) anyone have scripts or procedures for creating a 10.2 database with the compatibility parameter set for 9.2 using import and export? -- would hate to reinvent the wheel; and (2) anyone faced this and found a workaround that does NOT involve import and export?

Thanks in advance,

Mike Confused