Re: Data Files getting to large for Server

As a clarification on a correct point :

All objects in the SYSTEM tablespace should be owned by SYS. These are created when the database is created by the various catalog.sql, catexp.sql etc. scripts (depending on what options you installed).

You could list all the non-SYS objects :

select segment_name from dba_segments where owner != 'SYS' and tablespace_name = 'SYSTEM'

and then export these objects and re-import to a separate, more appropriate tablespace. This should allow you to unclench your teeth, for a while at least.

hth
NeilC.

Jerry Gitomer wrote in message <389A67D2.8BC67CA_at_erols.com>...
>john_falchetta_at_my-deja.com wrote:
>>
>> Our System Tablespace Datafiles through normal use are growing way
>> out of control. Any suggestions for reducing their growth?
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
> Do you have anything in the SYSTEM tablespace that wasn't created by
>Oracle?
>
> If so move it. If not all you can do is grit your teeth, resize the
>datafile
>for the tablespace, and hope for the best.
>
>--
>Jerry Gitomer
>Once I learned how to spell DBA, I became one.
Received on Fri Feb 04 2000 - 08:07:46 CST