Solved

ORA-01653: unable to extend table IFSAPP.SERVER_LOG_TAB by 8192 in tablespace IFSAPP_DATA

R
Rank
Userlevel 7
Badge +18

The Event Action CO_LINE_BLOCKED has failed.  Please contact your system administrator to manage the Event Actions.

ORA-01653: unable to extend table IFSAPP.SERVER_LOG_TAB by 8192 in tablespace IFSAPP_DATA

icon

Best answer by Himasha Abeywickrama 5 May 2021, 12:10

View original
This topic has been closed for comments

4 replies

Himasha Abeywickrama
Rank
Userlevel 7
Badge +18

Hi @johnw66 ,

 

Have you tried adding a new datafile for the existing tablespace?

ALTER TABLESPACE IFSAPP_DATA ADD DATAFILE '/u01/oradata/userdata03.dbf' SIZE 200M;

To find out the location and size of your data files:

SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'IFSAPP_DATA';

 

Hope this helps! 

https://www.linkedin.com/in/himashaabeywickrama
RanukaSerasinghe
Rank
Userlevel 5
Badge +7

@johnw66 Please note that It would be better to fix this as soon as possible as it could eventually lead to a System Down situation. Pls refer to Alter Tablespace Add Datafile:http://www.dba-oracle.com/t_alter_tablespace_add_datafile.htm

R
Rank
Userlevel 7
Badge +18

@Himasha Kapugeekiyanage Thank you very much, that resolved the issue.

@RanukaSerasinghe  Thank you for your input as well.

 

Have a nice day.

R
Rank
Userlevel 7
Badge +18

I have had the same error relating to a separate custom event.  

 

 

I have added another datafile, but am wondering why this is happening now?

ALTER TABLESPACE IFSAPP_DATA ADD DATAFILE ‘F:\oradata\IFSLCDB\IFSLPDB\IFSAPP_DATA04.dbf' SIZE 200M;

 

I am having a look at the SERVER_LOG_TAB to see what is eating the space.

 

Thanks  John

 

 

Terms & ConditionsCookie settings