import a full dump file

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