Upgrading to 9i

[Beantree]

I need to upgrade to 9i and am considering exactly how I want to upgrade.

I'm tempted to set up a separate instance and re-create all my tablespaces, and then import the appropriate schemas.

This way I don't get all the crap that has seemed to accumulate in the DB via installing various programs I never used.

I have a simple DB, only a few schemas, and probably less than 200 objects that we use.

Any opinions?

Thanks

 

[karluk]

For what it's worth, I'm in the middle of upgrading all our databases to Oracle 9i, and I'm using the method you describe. It seems to work ok. It can be time consuming with large databases, but that doesn't seem to be your situation.

The only specific problem I've encountered in the process is that one wrapped procedure causes the 9i import utility to fail. As a work-around, we needed to drop the stored procedure from the 8i database before exporting. Not a serious problem, but a warning that you should do a dry run first to detect this type of problem.

 

[Beantree]

Are you using transportable tablespaces to move the data?