Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: remove system01.dbf file?

Re: remove system01.dbf file?

From: Sam Wun <s.wun_at_thales-is.com.hk>
Date: Wed, 24 Apr 2002 22:22:24 +0800
Message-ID: <aa6f30$lg64@imsp212.netvigator.com>


Thank you for youre suggestion. I will try this out. "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> 写入消息新闻 :3cc69a22$0$230$ed9e5944_at_reading.news.pipex.net...
> 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?
>

how much do you charge?
>
> --
> 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
> > $
> >
> >
>
>
Received on Wed Apr 24 2002 - 09:22:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US