You can copy all the files from the original database create a trace file
from the controlfiles and past the files in the new database directory,
rename the directory paths in the trace file and rename the trace file to
.sql run it and run the alter database resetlogs command and you should be
fine. This method has worked for me if you need more of a step by step and
want to do this method let me know....many in this group helped me do this,
in this manner and it appears to be working fine so far.
"Brian E Dick" <bdick_at_cox.net> wrote in message
news:EFRZ9.53415$GX4.2081924_at_news2.east.cox.net...
Can you shutdown briefly during the cut over?
"Jackie" <jackie_ol_at_hotmail.com> wrote in message
news:2c196db8.0301290201.740ce2d6_at_posting.google.com...
> Oracle version and OS will be the same: Oracle 8i on Win 2000 Server.
> Only the hardware will be changed.
> Database size is 1gb approximately.
>
> "Brian E Dick" <bdick_at_cox.net> wrote in message
news:<fUyZ9.46154$GX4.1747969_at_news2.east.cox.net>...
> > Here's a different spin on a common question. What is your target Oracle
> > version and OS?
> >
> > "Jackie" <jackie_ol_at_hotmail.com> wrote in message
> > news:2c196db8.0301280102.568067e3_at_posting.google.com...
> > > Hi!
> > > We are using Oracle 8i running on Windows 2000. We are planning to buy
> > > a new, more powerful server and transfer our database to this new
> > > system. What is the best way to achieve this transfer process? We will
> > > install a fresh copy of Oracle to the new server and import existing
> > > data from old server. Is export-import enough or a different procedure
> > > should be followed?
> > >
> > > thanks.
Received on Sun Feb 02 2003 - 17:20:09 CST
