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
Solved
ORA-01653: unable to extend table IFSAPP.SERVER_LOG_TAB by 8192 in tablespace IFSAPP_DATA
Best answer by Himasha Abeywickrama
Hi
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!
This topic has been closed for comments
+18Hi
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
+7
Have a nice day.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.