Re: remove system01.dbf file?

I have to admit, I had the "you must be kidding" reaction as well.

There is nothing to stop you from adding another datafile to the SYSTEM tablespace, if your space problem is so acute, and when you can afford to EXPORT and so forth as Niall suggested, do it then.

This is something I've always dreaded, but's not yet happened to me, given what a pain SYSTEM is compared with other tablespaces; that's only because I grossly oversize it when I build the database.

A lot of people forget that SYSTEM doesn't only hold Oracle system stuff like the DD, and the other truly core things, but it also holds all views, all PL/SQL, all that sort of thing that users create. So a monster like Oracle Applications could eat an average SYSTEM tablespace for lunch and still have room for dessert and coffee.

Good luck!

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
> $
>
>
Received on Wed Apr 24 2002 - 13:21:08 CDT