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?
07-02-2002, 09:40 PM
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...
07-02-2002, 09:47 PM
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?
07-02-2002, 10:46 PM
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 .
07-02-2002, 11:37 PM
I did some test and when importing a full dump file, it doesn't need to create users.
07-03-2002, 01:24 AM
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.
07-03-2002, 01:37 AM
A question that sometimes drives me hazy: am I or are the others crazy?
07-03-2002, 09:05 AM
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.
07-03-2002, 06:57 PM
Below is how the import is going:
Import: Release 220.127.116.11.0 - Production on Wed Jul 3 11:40:25 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 18.104.22.168.0 - Production
With the Partitioning option
JServer Release 22.214.171.124.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.
07-03-2002, 07:03 PM
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.