Currently oracle 9.2i database was migrated to oracle 11.2g, we din't face any issue in migration, but is it possible to make oracle 11.2. to behave backward compatible to oracle 9.2 by modifying system parameter.

I believe that COMPATIBLE only refers to the bit-level format of files on disk, not to any client-related behavior (e.g. dictionary tables). I also believe that you cannot simply decrease COMPATIBLE without a risk of data corruption. Am I wrong?
–
kubanczykApr 6 '12 at 13:29