Home » RDBMS Server » Server Utilities » importing full db witout schemas to upper version
importing full db witout schemas to upper version [message #73917] Tue, 03 August 2004 01:55
jayesh
Messages: 6
Registered: December 2003
Junior Member
hi

i am planning to migrate from 8.1.7 to 9.01.i had a database in 8i i took a full export and want to import into 9i i created the database and tablespaces as in 8i.

 My dought is whether i have to create the  users is it a must because i already created the same tablespace because when we exporting full database the schema definitions will be exported that will contains the default tablespaces of  schema right?.

   so my dought is wheter i have to created schemas or not before import what will happen if i didnt do that.While importing the usres will be created as it is in the dmp file in the default tablespaces.pls clarify my doughts

with regards

jayesh

 

 
Previous Topic: exp error(about 15g data)
Next Topic: Statspack
Goto Forum:
  


Current Time: Wed Jul 03 18:01:08 CDT 2024