Re: Migrating Oracle WebDB to another machine.

If you are using the same version of the RDBMS, a simple way to do it is to:

1. Do a full export (Entire database) from the old system using exp
2. Drop the WebDB schema and any other schema's that you have created on the new system (since importing over this will cause problems with referential constraints, duplicate records, etc.)
3. Import the complete file you exported previously, with the option to ignore errors due to object existence

I have done this a number of times with Oracle 8.0.5, and it works quite well (albiet rather slow). I presume it will also work with 7.3.4, although I can't guarantee anything. What's the worst that can happen though? You may have to re-install the new DB if it goes screwy.

I hope this helps!

Steve.

Lukasz Feldman wrote:

> Hello!
>
> I buy bigger serwer for my department intranet portal based on Oracle 7.3.4
> and Oracle WebDB 2.1.
> Does anybody know a simple procedure how to migrate it to new machine? RDBMS
> and WebDB works
> on Windows NT 4.0.
> Whole day I was fighting with it. I installed database on a new machine than
> I installed WebDB.
> Using Export Utility I exported database from old machine and than I was
> trying to import it. Bu there where
> some mistakes and only forms and reports came to new machine. What to do?
>
> Lukasz Feldman
  Received on Thu Sep 07 2000 - 20:20:48 CEST