I just received a dump file from an export
taken from an 8.1.7 database from one of my company's
ofshore application.
I'm importing this data into a 9.2 database because
we have another application here that needs those
data to work.
During the import I realised that a lot of views
are being imported and these views have been
created using a rule hint (/*+ RULE */). I tried to get in touch
with the contractor that worked on this application
to find out why he used the rule hint,
but he is no longer with the company.

Since 9.2 uses the CBO, I'm thinking of recreating
the views without the rule hint. But I would test it
first.

What would you do if you were in this situation?