Re: Database Copy

Hello Joachim Muller,

  I have 2 methods -

  I Method :
  If you have the scripts for database creation, which you used to create the first
  database, then run this script on the 2nd NT server. So, a blank database   is created on your destination NT server. Now, take an export of the entire
  database using exp80.exe (Export utility of ORACLE) from the first NT database
  and import it into the Second NT database using IMPORT utility (imp80.exe).

  II Method :
  If you plan to create the the same directory structure on the Second NT Server
  as the First NT Server,

• shutdown the database on the First server.
• Create the exact directory structure on the second NT server. Copy the Datafiles files, control files etc to the second NT server and startup the database on the Second NT Server. (Note : You can later change the location of the datafile using commands like "alter database .....")

Regards,
Vinod.

Joachim Müller <j.mueller_at_douglas-informatik.de> wrote in article <37787CCF.D05E60A_at_douglas-informatik.de>...
> I have lots of experience administering DB2 UDB V5.x databases,
> but I'm just starting a project that will require me to learn
> Oracle for the first time. Can you help me get started by telling me
> how
> I can copy an Oracle 8.0.3 database from one NT system to another
> Oracle 8.0.3 database on NT (schema and data). Under DB2 I do
> a full backup of the Database and restore to 'new'...
> That's all.
>
> Thanks
>
> Joachim Mueller
>
Received on Tue Jun 29 1999 - 06:44:36 CDT