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
Received on Mon Apr 14 2003 - 14:33:08 CDT
