Can I move an Oracle 8i application to an Oracle 7 compliant database?

[IanBruk]

I have an application that was written using Oracle 8i as the database with triggers and stored procedures. I want to move this application to SAP DB. From what I read SAP DB supports Oracle 7 it does not expressly state that it supports Oracle 8i.

As I am trying to be downward compatible rather than upward compatible. Are their some features in 8i that would cause this to be a nightmare exercise?

 

[carp]

Yes, but if your application isn't using any of them (Java, LOBs, IOTs, etc), then you shouldn't have any problems.
The easiest way to find out is probably to export your application, import it into a test O7 database and see if it works. You should be able to tell right away - either the code will compile or it won't!

 

[jimbopalmer]

the Rule Based Optimizer has not changed since Oracle 6, but the cost based Optimizer is much improved in 8 so may do odd things to good 8 code in 7.

7.3 does have (undocumented) histograms if you type the command from an Oracle 8 manual it works! I love everyone til they prove otherwise, sadly some prove otherwise SO quickly