dbTalk Databases Forums  

Oracle Error

comp.database.oracle.server comp.database.oracle.server


Discuss Oracle Error in the comp.database.oracle.server forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Brian
 
Posts: n/a

Default Oracle Error - 09-06-2007 , 07:26 AM






I am getting the following error message on my oracle database. This is a
database that was created in 1999 and houses our MRP system for my work. I
get this error when trying to mass update one field in a table.

Error: ORA-01653: unable to extend table SYSADM.IC_STOCK_AUDIT by 27309 in
tablespace SYSTEM
ORA-27039: create file failed, file size limit reached
OSD-02067: illegal option specified
ORA-27039: create file

I assume there is a limit set on creation of this database. Is this a limit
per table (as in the IC_STOCK_AUDIT table) or is it a general limit for the
whole database. I guess what I need to know is, if I delete several
temporary tables created over the years, will it Band-Aid this for the time
being? Or would I need to delete records from the IC_STOCK_AUDIT TABLE?




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.