Steps to Extend table in Oracle 8i
I'm an app dev. who know's little about Oracle first of all. My users are getting errors from a third party app. that is no longer in business, that starts with...ORA-01653: unable to extend table. There are several tables that are at 90% or greater of the MAXBYTE field in dba_data_files. The one that is throwing the error is at 99.17% an has a memo field. It has AUTOEXENSIBLE = YES. It looks like I need to extend the tablespaces. I thought I could run a qry like this...Update dba_data_files set MAXBYTES = 3000000000 WHERE file_name=''E:\ORACLE\ORADATA\ORCL\TABLE_NAME.DBF''. I appear not to have permissions. Thats one issue. The current size in the MAXBYTES field is roughly 2090000000. I hoping someone could give me the steps that I need to take to extend the table.