December 30th, 2003, 07:24 AM
Data migration from oracle to oracle
I am a newcomer to this forum. Just one day old to this forum. I would like to know in detail the migration of tables from oracle database say(abc) to oracle database say( cba) as I got to install a softwre that our company uses in Dubai, to be used in Spain office(newly opening) with a few default database to be transfered to avoid reentry of the same. Kindly guide me in this regard. I checked the Oracle enterprise manager console has the facility to export data, but the same requires the OMS, which is a part of the 3 tier structure of oracle. If I try doing this it instructs me to launch OMS before doing this opern.
December 30th, 2003, 10:14 AM
Set up a dblink between the two and then copy or recreate the tables in the new database.