Re: What problems do a lack of Tablespace cause?

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<aTDma.14387$1s1.236578_at_newsfeeds.bigpond.com>...
> System should always be autoextend. And it shouldn't have any tables of your
> own in it, period. And if System ever does run out of space, your database
> (at the very least) will crash, and quite possibly introduce corruption.
>
> Regards
> HJR
>
> "Tim Bedford" <timbedford_at_hotmail.com> wrote in message
> news:a411bafb.0304140502.59df2510_at_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

Thanks very much for the wise words.
cheers,

Tim Received on Tue Apr 15 2003 - 05:02:09 CDT