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

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,
2. Copy the "dbs" and "database" folders within oracle installation directory,
3. Re-start the services.

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

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 Thu Dec 26 2002 - 21:44:40 CST