1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    At present in Dubai
    Rep Power

    Data migration from oracle to oracle

    Hi there!

    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.

    Reply asap.

  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Outside US
    Rep Power
    Set up a dblink between the two and then copy or recreate the tables in the new database.

IMN logo majestic logo threadwatch logo seochat tools logo