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

Thread: imp hangs

  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 03:17 AM.

  2. #2
    Join Date
    Jan 2007
    Posts
    231
    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
  •  



Click Here to Expand Forum to Full Width