Hi: our DBA is on vacation and my application is getting the following error
ORA-01653: unable to extend table REMEDY.INTERFACE by 8192 in tablespace REMEDY
SQL> select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='REMEDY';
FILE_NAME
--------------------------------------------------------------------------------
BYTES AUT MAXBYTES
---------- --- ----------
/oracle/g01/oradata/prod/remedy01.dbf
2147483648 YES 2147483648
Any suggestions on what I should to temporarily fix this until our DBA comes back 2 days from now. I know I need to run alter database datafile '/oracle/g01/oradata/prod1/remedy01.dbf' resize XXXXm;
What should the XXXXX be?
Thanks
Ravi