imp hangs

[ams-jamali]

hi all,

I have imported data from prod to testdb while importing it imports 24tables and on 25th table it hangs.

Import file: expdat.dmp > f1.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by ISHADMIN, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
IMP-00046: using FILESIZE value from export file of 2097152000
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no > yes

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no > yes

. importing ISHADMIN's objects into TEST
. . importing table "ABC" 39 rows imported
. . importing table "ACCOUNTS_PAYABLE_EMPLOYEE" 0 rows imported
. . importing table "ACTION" 12 rows imported
. . importing table "ACTIVE_PERSON_SNAPSHOT" 6537 rows imported
. . importing table "AFFILIATE" 44 rows imported
. . importing table "AFFILIATE_BILLING_REPORT" 876 rows imported
. . importing table "AFFILIATE_PAYMENT" 0 rows imported
. . importing table "AFFILIATE_SERVICE" 251 rows imported
. . importing table "AGGR" 15464 rows imported
. . importing table "AMT_ACTIVITY_DETAIL" 8 rows imported
. . importing table "AMT_ADMIN_TYPE" 2 rows imported
. . importing table "AMT_BILL_UPGRADE" 4 rows imported
. . importing table "AMT_CREDIT_ADJUSTMENT" 6 rows imported
. . importing table "AMT_DISCOUNT" 1 rows imported
. . importing table "AMT_EMAIL" 11 rows imported
. . importing table "AMT_EMAIL_TRANS" 4782 rows imported
. . importing table "AMT_PROGRAM_TRACK" 35 rows imported
. . importing table "AMT_USER_DETAIL" 4 rows imported
. . importing table "AMT_USER_LOG_AUDIT" 121 rows imported
. . importing table "APPEARANCE_GOAL" 3 rows imported
. . importing table "ASSESSMENT" 103969 rows imported
. . importing table "ASSESSMENT_SKILL_TEST" 492840 rows imported

then it hangs


when i opened another session to that account it hangs

SQL> conn test/test
ERROR:
ORA-01013: user requested cancel of current operation

Error accessing package DBMS_APPLICATION_INFO
Connected.

this test account is given sysdba and imp_full_database privs.

immediate help needed..
Thanks in advance

[ams-jamali]

hi all,

I have rectified the problem, one of the datafile user04 was kept offline and it checks for that file.
after bringing that file to online it is working fine.



Another question?

in interactive mode (for import)can i give more than one dmp file at a time separated by commas.