Re: Better method for importing?

You can always go use the upgrade/migration path using the utility. However, that's no less comples than any of the options you have mentioned.

This is my experience:

Create a 8.1.7 database. Do a full
import of your exported 7.3.4 database.
It's going to be OK. At the end of the process, run the script under rdbms/admin taht recompiles all procedures etc. in the entire database.

or

just simply create three users
and use the fromuser and touser option, as you mentioned. of course , you will
created other users who will need grants from these three main schemas.

I personally like this 2nd option as it
gives me a sense of control of what steps I am going through.

The first option of full export import is also OK, it's not as messy as you may
be thinking.

Regards
Willy Received on Thu Mar 08 2001 - 22:39:39 CST