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.
alter database datafile 'E:\ORACLE\ORADATA\ORCL\TABLE_NAME.DBF' resize XXXM;
just make sure you have enough free space on disk to do that.
Also you dont extend tables, you extend tablespaces.
never ever do you update data dictionary tables (you cant anyway becuase they are views)
but never even try to do that
Click Here to Expand Forum to Full Width