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
Bookmarks