Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013

    Unanswered: converting DDL from DB2 to Oracle

    Hi all,

    This is the first time i'm converting a db2 luw 9.7 fp 8 database structure (no data) into Oracle 11.2. I've been trying sql developer for few days but the migration wizard is just not moving past the "creating tables" phase under "installing repository" phase of the migration. i haven't waited longer than 2 hours though - I feel as if it shouldn't take so long to convert just the structure

    I read that i could multi-select the tables and then "copy to oracle" but that omit's relationships (SQL Developer: Migrating Third-Party Databases). I could take this route granted an easy process to set up parent-child relationships.

    Could someone please guide me towards light on an automated process to convert my db2 database objects with relationships.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts