topic Re: Move Schema in Operating System - HP-UX

Move Schema

Prabhu_7 — Fri, 05 Mar 2004 09:53:52 GMT

Hi,

I have schema called BSA in DATABASE1 in SERVER1.

Now i need to move / mirror (with data)the entire schema to DATABASE1 in SERVER2.

Which would be the best method to do this ?

Thanks.

Re: Move Schema

Jean-Luc Oudart — Fri, 05 Mar 2004 10:25:54 GMT

Is this Oracle ?

to copy a schema with data you can use :
"export" from db1/server1
copy dmp file to server2 (ftp, ...)
"import" into db1/server2

specify OWNER=BSA in the parameter file (or command line)

Regards,
Jean-Luc

Re: Move Schema

Prabhu_7 — Fri, 05 Mar 2004 11:57:25 GMT

Sorry. Yes this is oracle 8.1.7

Export is the best method ?
some says DBLink should also work but need to create objects manually.

Thanks anyway. i go for export and import.

Re: Move Schema

Prabhu_7 — Tue, 09 Mar 2004 11:14:50 GMT

Hi..

I have moved the whole schema from server1 to server 2.

I checked num of tables and count of records in each table and found expect for you rest all got right counts.

Now , how do i check whether all constraints and other objects have moved properly.
Is there any quick way to double check this ?

What else need to be done to make sure we have the exact replica of the schema in server2 ???

Thanks

Re: Move Schema

Sanjay Kumar Suri — Thu, 11 Mar 2004 00:13:44 GMT

Exp and imp have a option LOG where you can specify logfile that receive informational/error messages.

This logfile can be used for comparison.

sks