Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Interesting (painful) Migration Problem (Nov 7.2.2.4.10 -> NT 7.3.3.0.0)

Re: Interesting (painful) Migration Problem (Nov 7.2.2.4.10 -> NT 7.3.3.0.0)

From: Hero R. Post <HERO.POST_at_ORAP.NL>
Date: 1998/03/27
Message-ID: <6fnbsi$hvp3@reader2.wxs.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US