Before I import a full dump file (the export was done by system user) as system user, do I need to know which users I need to create manually in order to import data belonging to those users or the import utility will automatically create necessary users and/or other things?
if its a full database export oracle will create all the users in the database...if its a schema dump you need to know to which user you want the database to dumped...
So I just create a new database instance, and then import as system user? The import utility knows what should be created and will not give 'users not existed' error?
what exactly u want , u want schema users dump or full database dump.
U can use the parameter show=y in import to see the contents of the export dump file u have .
I did some test and when importing a full dump file, it doesn't need to create users.
Are the tablespace name same in the instance where u want to import it.
As long as the tablespace exist full database dump will create the users.
A question that sometimes drives me hazy: am I or are the others crazy?
Jiong, Could you please paste your imp command. Full import should create all the users in dmp file.
And vendechukp, please refrain from distracting the main discussion.
Below is how the import is going:
Import: Release 188.8.131.52.0 - Production on Wed Jul 3 11:40:25 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 184.108.40.206.0 - Production
With the Partitioning option
JServer Release 220.127.116.11.0 - Production
Import file: expdat.dmp > data_c.dmp
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V08.01.06 via direct path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and US7ASCII NCHAR character set
List contents of import file only (yes/no): no >
Ignore create error due to object existence (yes/no): no >
Import grants (yes/no): yes >
Import table data (yes/no): yes >
Import entire export file (yes/no): no >
Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:
. . importing table
IMP-00009: abnormal end of export file
IMP-00028: partial import of previous table rolled back: 1835351 rows rolled bac
Import terminated successfully with warnings
Also, I checked the alert.log file under bdump and found the following error:
ARC0: media recovery disabled
Thread 1 cannot allocate new log, sequence xxx
Checkpoint not complete
Is this something with archivelog mode? I checked the instance and it has ARCHIVE started. However, under the directory where the archivelog files are supposed to store, there is no file there.
Anyway, I am still investigating this. I would appreciate any opinion or suggestion from you.
yes when it says that whether u want to import the entire export file u have said NO.
Then secondly when u said NO for the entire export file u it asked u username there also u have kept it blank.
Thirdly when it prompted for table , u should have entered table names. There also u have put it blank.
If u want to import the entire dump u should say YES in the parameter import entire file.
As i said ealier that as long u have tablespaces created in your new instance a full import will create users fro u.