Steps to Extend table in Oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Steps to Extend table in Oracle 8i

  1. #1
    Join Date
    Jul 2009
    Posts
    1

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width