Import Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import Error

  1. #1
    Join Date
    Jul 2001
    Posts
    40
    Hi,

    I'm getting the following error.

    IMP-00003: ORACLE error 604 encountered
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01653: unable to extend table SYS.IDL_UB2$ by 27309 in tablespace SYSTEM
    IMP-00017: following statement failed with ORACLE error 4043:
    "ALTER PROCEDURE "CK_INS_SALES" COMPILE TIMESTAMP '2001-09-06:16:56:01'"


    What to do. The free space of system tablespace is 400 mb.
    And the system and database have the current date.

    How to solve this problem? What is the use of IDL_UB2$
    table?

    Help me.

  2. #2
    Hi,

    from what I see your SYSTEM tablespace is full and hence the problem! Increase the tablespace size and then try to import it should work!

    Thanks,
    -S

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