-
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.
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
|