import a full dump file

[jiong]

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

[anandkl]

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

[jiong]

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

[pravin]

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 .

[jiong]

Hi,

I did some test and when importing a full dump file, it doesn't need to create users.

Thanks,
Jiong

[pravin]

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.

[vendechukp]

A question that sometimes drives me hazy: am I or are the others crazy?

[patel_dil]

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.

[jiong]

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

[pravin]

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.