Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Interesting (painful) Migration Problem (Nov 7.2.2.4.10 -> NT 7.3.3.0.0)
Hi there,
I do have experience with the same migration.
The trick is to create the database with the same tablespaces as the
original database and create all the users (with the same names) as they
exist and own objects on the source system.
Import will try to create all objects in the tablespace it imported them
from.
The tablespaces are Oracle items and are platform independent. The datafiles
are platform/installation specific, that is the reason you have to create
the tablespaces in your new database.
All the object will be created for the users by import.
This worked fine for me.
Good luck
Received on Fri Mar 27 1998 - 00:00:00 CST