Re: Moving Oracle 8.1.5.1.0 to different hardware

On Dec 21, 5:26 am, "VB" <vodkablo..._at_gmail.com> wrote:
> Mark D Powell wrote:
> > On Dec 20, 10:04 am, "VB" <vodkablo..._at_gmail.com> wrote:
> > > Hi,
>
> > > I have very little experience with Oracle, but I want to move a legacy
> > > 8.1.5.1.0 database from an NT box to windows 2000. The reason for this
> > > is the legacy database was one of several databases on the NT Box, and
> > > is now the only application / database in use. I have got a smaller
> > > storage server which can run the database to the end of days.
>
> > > So, anyway...
>
> > > I install Windows & Patches. Oracle 8.1.5.0.0 no problem, no database
> > > installed.
>
> > > When I run the setup.exe the advice is to shut down the instance in the
> > > normal way. Because there is no database I can not connect internal and
> > > give the shutdown command.
>
> > > Can someone enlighten me how to apply the 8.1.5.1.0 patch to a clean
> > > install?
>
> > > Many thanks
>
> > Exactly how did you install 8.1.5 on the new server?
>
> > How did you plan on moving the db? (exp/imp, file copies, etc)
>
> > HTH -- Mark D Powell --Installed from the installer, custom choice with no database installed.
>
> I have an exp of the current database, so was going to create the same
> tables and such and carry out an import.- Hide quoted text -- Show quoted text -

I would use a script to create the database and predefine all the tablespaces that the current database uses. I would then run time imp full=y log=mylog buffer=1048576 etc... against this new database and let the import create the user and their objects. Predefining the tablespaces lets you change the file names if desired and build each tablespace with only one file if it was built with multiple files if desired.

HTH -- Mark D Powell -- Received on Fri Dec 22 2006 - 11:28:05 CST