Re: remove system01.dbf file?

RSH wrote:

> Oh-- in re Niall part II:
>
> I forgot about users defaulting to the SYSTEM tablespace, yes, that could
> rather be a mess.
>
> A quick way to find out just how bad it is before you decide what to do
> would be:
>
> SELECT
> owner, (sum(bytes/(1024*1024)))
> FROM
> dba_extents
> WHERE owner not in ('SYS','SYSTEM') AND tablespace_name = 'SYSTEM'
> GROUP by owner
> ORDER by owner;
>
> RSH.
>
> "Sam Wun" <s.wun_at_thales-is.com.hk> wrote in message
> news:3CC67DDA.DA35C145_at_thales-is.com.hk...
> > Hi,
> >
> > I found that the system01.dbf file has increased to its maximum. How can
> > I reduce its size? or can I remove this file?
> >
> > Thanks
> > Sam
> >
> > The file is located at:
> >
> > $ ls -l /tempo/u02/oradata/tke/system01.dbf
> > -rw-rw-r-- 1 oracle dba 1897930752 Apr 24 17:35
> > /tempo/u02/oradata/tke/system01.dbf
> > $
> >
> >

And lets not forget all of the people that leave SYSTEM as the default temp tablespace too.

Daniel Morgan Received on Wed Apr 24 2002 - 14:21:22 CDT