Re: remove system01.dbf file?

i'm suspecting that the Windows database was created by the wizard, which defaults just about everything to the system tablespace. Additionally, most Oracle tools during installation will default to the system tablespace as well.

your best solution is to reorganize or rebuild your database...but be certain you have a GOOD backup (ie test it!). by the way, you need to read about removing, altering the database, control and parameter files --- if not done correctly, making changes may destroy your instance and you'll end up rebuilding from scratch. ouch!

i think that the DBA HANDBOOK has a very good section on database design. You might want to peruse this first.

It might be possible to export by user, dump the database, rebuild the structure manually, and then import the users into their new tablespaces. You should also examine your temporary tablespace because i believe the default installers stuff everything into that also.

"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 - 15:31:15 CDT