Re: move database to new server/directory

gazzag wrote:
> Charles Hooper wrote:
> > > > I do agree that you should not export, delete the database, and import
> > > > to "improve" performance. There are great risks with this practice,
> > > > and it has been covered from time to time on asktom.oracle.com.
> > >
> > > This is a technique? Not familiar with that flawed approach.
> >
> > Exporting the database, deleting the database, and importing the
> > database was annouced as a recommended practice to be done twice a year
> > during the Oracle session at the Infor (now the third largest ERP
> > company) conference this past April. Also included in the
> > recommendations during the session: RAID 5 should be used for the
> > tablespaces that store database data, a new _tablespace_ should be
> > started when the current _tablespace_ exceeds 2GB because it will make
> > the database faster. The session was littered with such suggestions.
> > Their support site suggested the following for dealing with objects in
> > the recycle bin that caused problems when adding users to the
> > application: "delete from SYS.OBJ$ where name like 'BIN%' and name not
> > like 'BINARY%';"
> >
> > With tips like these offered by application developers, it is easy to
> > see how the experts on this group can significantly improve Oracle
> > configurations at customer sites. It must be interesting to walk into
> > some of these sites.
> >
> > Charles Hooper
> > PC Support Specialist
> > K&M Machine-Fabricating, Inc.
>
> Wow. What did they mean by "deleting the database"? Based on the rest
> of the "advice" they give, I guess this is fairly academic, but I'm
> curious. Do they mean deleting the relevant datafiles at O/S level or
> simply dropping a schema?

If they knew about the DROP DATABASE command that was added to 10g, they probably would have recommended using that. If I recall correctly, something like ORADIM -DELETE -SID xxx, and then start fresh was recommended. I talked to a couple customers who attended the Oracle session at the conference, and one of them wondered if there was a problem with only doing this once per year. I am fairly sure that that customer is no longer following this procedure.

One more from that conference session related to using the exp command: specify COMPRESS=N because there is no need to compress the export file, just use Winzip before sending the export file to us - or something along those lines. The parameters that were recommended were correctly, but for the wrong reasons.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Nov 17 2006 - 08:34:57 CST