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@bigfoot.com> wrote in message news:<asp0b3$31du$1@news.hgc.com.hk>...
> Would you please what files I have to copy?
>
> Thanks.
> "Ban Spam" <ban-spam@operamail.com> wrote in message
> news:Xns92DBB436C5D42SunnySD@68.6.19.6...
> > "HK Chang" <REMOVETHIS_hkchang@bigfoot.com> wrote in
> > news:ask5lc$kv7$1@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. |