Oracle 11g setting for backwards compatibility? Edit: Please close this topic.

Unfortunately, this issue can't be resolved as it turned out the question is very off-base to begin with. The actual issue was completely unrelated to the question I asked.



We are experiencing a data inconsistency issue after importing an exported Oracle 9i database into Oracle 11g.

Is there a setting that might facilitate this process better? A "compatibility-mode" settings or group of settings of sorts?

I'm looking for an extra lead that might help our DBAs, who are a little new to these sorts of issues I think, as this import falls outside of their normal process.

Thanks in advance for any help! Happy to provide more information as needed.
Take a look at the COMPATIBLE initialization parameter both here and here. These links are more to do with when you upgrade a database rather than import into a higher version but it should help if, perhaps, you can import your data into a cloned 9i database (so as not to mess up your original database) then upgrade that with the compatibility setting on to 9i.