Re: remove system01.dbf file?

You *can* do either of these things. Then you will have an unusable database.<g>.

However it looks to me (remember I'm most familiar with NT) as if your system tablespace is now the best part of 2gb in size. This strongly suggests to me that you have application data sat in the middle of the oracle data dictionary, this would be what would happen if you did a default installation and took defaults for all the users etc you created. Your best strategy to resolve this situation - if it is indeed the one you find yourself in - is to export your database, recreate from scratch. create users with appropriate default tablespaces (and zero quota on system) and tablespaces with appropriate storage clauses then reimport with ignore=y and indexes=n.Because the user has no quota on system the tables will be recreated in the default tablespace for the user. Then you can recreate the indexes in an appropriate tablespace. Bear in mind that I am assuming a fair few things here based on the size of the system01.dbf datafile.

How much does a Thales Oracle Consultant get charged out at these days?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"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

> $

>

>