Full exp 8.1.7 and Full imp 9i
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?
Click Here to Expand Forum to Full Width