-
Hi,
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?
Thanks,
Jiong
-
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...
regards
anandkl
-
Hi anandkl,
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?
Thanks,
Jiong
-
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 .
-
Hi,
I did some test and when importing a full dump file, it doesn't need to create users.
Thanks,
Jiong
-
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.
-
Hi Dilip,
Below is how the import is going:
$ imp
Import: Release 8.1.6.0.0 - Production on Wed Jul 3 11:40:25 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Username:
Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.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 >
Username:
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
k
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.
Jiong
-
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.
-
Hi pravin,
I was trying to import only schema belonging to one user, not the entire dump file. The import proceeded for a while and imported some tables successfully, then ended while importing a large table.
Jiong
-
Hi pravin,
Now i got it , u want to have a USER created from the EXPORT FULL DUMP.
imp userid =system/manager fromuser=xxxx touser=xxxx file=export.dmp.
try doing this.
once u do this u will have the user and all the schema objects created.
Good luck. if u require any thing please question
-
I used user_a to import schema belonging to user_a from a full dump file. The import proceeded for a while and successfully imported some tables then ended abnormally while importing a big table (see the record of the whole process in my previous post). I think I get the import started correctly. However, it ended in the middle of the import. I suspect the database could not start the archivelog so the import stopped. Hope this time I explained my question clearly.
Thanks,
Jiong
-
Hi,
IMP-00009: abnormal end of export file
I suspect input file corruption or incompleteness.
Try reading input file from start to end using...
imp system/manager file=fname show=y full=y