-
imp hangs
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
Last edited by ams-jamali; 05-10-2007 at 03:17 AM.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|