Re: database keeps growing

Paul Brewer wrote:
>
> "zulijid_at_hotmail.com" <aersdjes_at_hotmail.com> wrote in message
> news:abm13f$2im$06$2_at_news.t-online.com...
> > hi,
> >
> > our oracle database is growing and growing, but we update only data
> >
> > every minute it produces new files,
> >
> > can we delete some of the oldest files like system.dbf ??
> >
> > why is this crap so slow , our dba told us it is time for a complete
> rebuild
> > of the database.
> >
> > oracle says every month the database must be rebuilded for good
> performance
> >
> > progress was much better than oracle
> >
> By all means; here's the syntax:
>
> sqlplus /nolog
> connect / as sysdba
> drop user zulijid cascade;
> shutdown abort
> !rm /databases/$ORACLE_SID/data/*

To save time you can do it without the "drop user..." statement because of the last line.

Regards,

Knut Received on Thu May 16 2002 - 02:05:53 CDT