I have got the following error when importing few of my package bodies and triggers. ORA-01653: unable to extend table SYS.IDL_UB1$ by 13 in tablespace SYSTEM The tablespace SYSTEM had enough space at the time of import. Later when I tried to create theses objects seperately through a script, they were successfully created. It is important to note that not all package bodies and triggers failed. If you have any idea regarding this error, please let me know the problem and solution, if possible.

Questions by shailzone_dba

Showing Answers 1 - 4 of 4 Answers

srilakshmi

  • Dec 30th, 2005
 

I GUESS TRIGGERS AND PACKAGES IN TABLESPACES CAN BE IMPORTED PROVIDED U HAVE PERMISSION FROM DBA..OR ELSE ONLY DBA CAN IMPORT THEM IN TABLESPACES SINCE THEY R CREATED BY DBA...

  Was this answer useful?  Yes

Jaya

  • May 29th, 2007
 

Hi ,

Check the space in SYSTEM table space ,if no sufficient space exists we will receive such error and make sure the user importing has IMP_FULL_DATABASE role or DBA role since you are importing system objects.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions