imp hangs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: imp hangs

Threaded View

  1. #1
    Join Date
    Jan 2007
    Posts
    231

    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 04: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
  •  


Click Here to Expand Forum to Full Width