What to look for when downgrading from Oracle 10g to 9i?

Question

I need to downgrade my Oracle instance from 10g (10.1.0.2.0) to 9i (9.2.xxx). Without planning to ever do this, I did not document the 10g dependencies.

What are some 10g dependencies that I have to solve?

Is there any type of request I could execute to detect dependencies?

Of course, I hope for a magic bullet without sifting through volumes of parts to compare with 100 klocs PL / SQL.

By the way, we do not lower the database in place, we are transferred from the 10g instance to a separate 9i instance.

Answer 1

Take a look at the Oracle 10G New Features documentation to find out what you don't need to use.

Answer 2

, 9i, ​​ - ..

10g 9i, . , .

Answer 3

( ). , :

• 10g.
• (CONNECT_BY_ISCYCLE, NOCYCLE,...)
• ( , varray ,...)
• - ( SQL MODEL).

@tony-andrews: , 10g, , , , .