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