Re: bringing together two different databases (with different schemes) into one database

How big the schmeas are in those database? I think export and import would be a good idea in this case.
Take schema export from one database and import it in the a database where you want.

For an example,
On database A
exp system/password_at_tnsname file=username.dmp log=username.log owner=user_name_which_you_want_to_export direct=y statistics=none

On Database B
Create a similar user and with the exact default tablespace (for convineance purpose).
Once done with user creation.
imp system/password_at_tnsname file=username.dmp log=imp_username.log fromuser=username touser=username statistics=none

once you see 'imported successfully finished without warning', then analyze the newly imported schema in database B.

For more help, search at http://asktom.oracle.com site. Received on Tue May 03 2005 - 06:42:11 CDT