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.
RE: I have got the following error when importing few ...
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...
RE: I have got the following error when importing few ...
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.
RE: 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 t
