Home » RDBMS Server » Server Administration » ORA-01653: unable to extend table (Oracle 11.2.0.4.0)
icon5.gif  ORA-01653: unable to extend table [message #684111] Wed, 07 April 2021 08:31 Go to next message
ak1900
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: 8922
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: Thu Mar 28 09:45:20 CDT 2024