Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Posts
    4

    Red face Unanswered: Can DB2 Timestamp be populated directly into Oracle

    Hi Friends,

    I am with task of Migrating DB2 data into Oracle and facing problem with Timestamps fields.Does any format change required before populating it into Oracle. I am able to insert the records in to Oracle, but unable to view the timestamp fields in Oracle.Please do help me solving this problem.
    I am using Hibernate/java as ORM Mechanism to migrate data from DB2 to Oracle. I feel problem is specific to DB2 to Oracle conversion. Would need suggestions to resolve this.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Why no use the free oracle conversion tool, it takes care of everything. see

    http://www.oracle.com/technology/tec...nch/index.html
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Apr 2008
    Posts
    4

    Red face

    Thanks for an link, but its an assignment and need to be completed.....

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    exactly, unless it is homework, download the utility and it will migrate the DB2 database into an oracle database.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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