Move Schema

[Prabhu_7]

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.

[Jean-Luc Oudart]

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

[Prabhu_7]

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.

[Prabhu_7]

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

[Sanjay Kumar Suri]

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