Re: remove system01.dbf file?

AUGH. Yes. That too.

It's only been 100 years, you'd think any user but sys or system would require explicitly specified default tablespaces and temp tablespaces in their CREATEs, and perhaps even forbid use of SYSTEM to be specified for any users other than sys or system (or other special Oracle internal users) in CREATE or ALTER user statements.

RSH. "Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message news:3CC705A0.996828E5_at_exesolutions.com...
> 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:56:00 CDT