ORA-01653: unable to extend table by 128 in tablespace SYSUTIL

[gandolf989]

You might also try alter tablespace SYSUTIL coalesce;

[gandolf989]

Check fragmentation.

Check fragmentation???? How old fashioned!!!!

Do we still use VT's for our terminal sessions?

[gopu_g]

So it could be that you need to do PURGE DBA_RECYCLEBIN; to free up space in your tablespace.

Good answer, surely we will check it

[gopu_g]

You might also try alter tablespace SYSUTIL coalesce;

We have tried that, but did't help, Even we have suggested the same from Oracle first and after that they have came up with this as a bug, so we are just waiting to release that, thanks a lot for your valuable answer, i will go with your suggestion.

[gandolf989]

You should check the PCT_INCREASE for the ORAAUDIT.AUDIT_DDL_LOG table. If it is set high it will try to grow the size of each new extent.

select PCT_INCREASE from dba_tables
where owner='ORAAUDIT' and
table_name='AUDIT_DDL_LOG';

[gopu_g]

Thanks gandolf

[PAVB]

Check fragmentation???? How old fashioned!!!!

Do we still use VT's for our terminal sessions?

you made may day man - I'm an old fart - LOL