OraFAQ Forum: Server Administration » ORA-01653: unable to extend table

Home » RDBMS Server » Server Administration » ORA-01653: unable to extend table (Oracle 11.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01653: unable to extend table [message #684111]

Wed, 07 April 2021 08:31

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!

Report message to a moderator

Re: ORA-01653: unable to extend table [message #684112 is a reply to message #684111]

Wed, 07 April 2021 09:10

John Watson
Messages: 8783
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;

Report message to a moderator

Previous Topic:	Not able to hot clone remote pdb with same name
Next Topic:	Export and Import of huge schemas

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 08 11:33:43 CST 2022