Hi,

i'm trying to make a migration from 8.1.7 to 9i. Both are on the same Machine, with Windows XP (please don't blame me...)

It's my first attempt to make a full exp, so i'm guessing it's a dummy mistake, but HOW do i get the users into the new database?

I've found different suggestions. Some are saying that i have to create the users, tablespaces and roles manually in 9i.
Is that right? If yes, How can i do that, efficient?

I tried to find the "create user" statements in the error.log
(imp userid='sys/sys as sysdba' file=exp_8_1_7.dmp log=error.log full=y indexfile=index.sql show=y)
but they aren't there.

Here are my Import/Export statements :

exp userid='sys/sys as sysdba' file=exp_8_1_7.dmp log=error.log full=y consistent=y

imp userid='sys/sys as sysdba' file=exp_8_1_7.dmp log=error.log full=y ignore=y

Any Idea of what i'm missing here?

thanks,
Stefan