Re: How to duplicate whole database from one machine to another machine in Windows 2000?

[Quoted] [Quoted] If you are using a version of Oracle that is less than 8i, you could follow the following steps..

1. Shut down the database services, [Quoted]
2. Copy the "dbs" and "database" folders within oracle installation directory,
3. Re-start the services.

[Quoted] Remember the machine to be copied to should also have its services shut down

[Quoted] Ideally, you have to copy only selected files from "dbs" and "database", but I am not an expert at that and can just say that copying all the files in the 2 folders - "dbs" and "database" used to work for me.

If the database is very big ( approx > 200MB) you will have to export it though.

Laxman

"HK Chang" <REMOVETHIS_hkchang_at_bigfoot.com> wrote in message news:<asp0b3$31du$1_at_news.hgc.com.hk>...
> Would you please what files I have to copy?
>
> Thanks.
> "Ban Spam" <ban-spam_at_operamail.com> wrote in message
> news:Xns92DBB436C5D42SunnySD_at_68.6.19.6...
> > "HK Chang" <REMOVETHIS_hkchang_at_bigfoot.com> wrote in
> > news:ask5lc$kv7$1_at_news.hgc.com.hk:
> >
> > > Dear All,
> > >
> > > Do you know how I can duplicate the whole database from one Windows 2000
> > > machine to another Windows 2000 machine?
> > >
> > > Thanks.
> > >
> > > Regards,
> > > HK Chang
> > >
> > >
> >
> > I'd just use COPY when the database is shut down.
Received on Fri Dec 27 2002 - 04:44:40 CET