Home » RDBMS Server » Server Administration » ORA-01653: unable to extend table (Oracle
icon5.gif  ORA-01653: unable to extend table [message #684111] Wed, 07 April 2021 08:31 Go to next message
Messages: 1
Registered: April 2021
Junior Member
Dear colleagues!
Since recently I found a recurring error in alert.log:
ORA-1653: unable to extend table SYS.SCHEDULER$_EVENT_LOG by 128 in tablespace SYSAUX
AUTOEXTENSIBLE of a file with SYSAUX is switched on.
Help me please solve this problem. I will appreciate it very much!
Re: ORA-01653: unable to extend table [message #684112 is a reply to message #684111] Wed, 07 April 2021 09:10 Go to previous message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

What does this show you:
select BYTES,USER_BYTES,AUTOEXTENSIBLE,MAXBYTES from  dba_data_files where tablespace_name='SYSAUX';
select OCCUPANT_NAME,SPACE_USAGE_KBYTES from v$sysaux_occupants order by 2;
Previous Topic: Not able to hot clone remote pdb with same name
Next Topic: Export and Import of huge schemas
Goto Forum:

Current Time: Fri Mar 01 00:22:02 CST 2024