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

    Red face Unanswered: Can DB2 Timestamp can be directly loaded 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 2003
    Toronto, Canada
    Provided Answers: 1
    Before you get any meaningful answer to your question you would need to define the "unable to view the timestamp fields in Oracle" part in more detail. Is your monitor switched off? May be you don't have Oracle installed? Do you get ORA-01555?
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2008

    Red face

    With my process data is getting loaded and I am able to query all different attributes except Timestamp.What might have went wrong?

  4. #4
    Join Date
    Oct 2007

    Migrating Dates from DB2 to Oracle

    Dates and datetime stamps are different from one database to another...thus always an "issue" when migrating, converting, or integrating data between databases. If you aren't opposed to using a 3rd party tool to migrate your data between DB2 and Oracle, you should take a look at the Pervasive DataTools product called Data UpLoader to Oracle. It includes the ability to convert datetime automagically between DB2 and Oracle.

Posting Permissions

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