Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What problems do a lack of Tablespace cause?

What problems do a lack of Tablespace cause?

From: Tim Bedford <timbedford_at_hotmail.com>
Date: 14 Apr 2003 06:02:54 -0700
Message-ID: <a411bafb.0304140502.59df2510@posting.google.com> 





Hi,


I have a fixed size table stored in the system tablespace, which is
running at 98% full. Can anyone tell me what actual problems this
might cause? I can find lots of references that say it is 'bad', but
not why or what would happen.



Could this error be caused by a lack of tablespace?
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\SID\REDO02.LOG'



If so would setting AUTOEXTEND to ON remove any dangers?
thanks,



Tim
Received on Mon Apr 14 2003 - 08:02:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US