Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: Migrate to tables from DB2 to ORacle

    Hi,

    How can i migrate a few tables from DB2 to Oracle.This is for a test enviornment.I would like to create a script.to run the insert.the difficult thing is to populate the data.

    Pls help.
    mickykt

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    from DB2 make an ascii delimited export

    for Oracle take sqlldr Utility and bulk copy in the data to an Oracle schema of your choise ..

  3. #3
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    CLOB import Problems

    Hi guys,

    Thanks for ur reply.I used SQLLDR,It was greate.

    I also user the SQLWay tool,I worked fine,for all tables except one,with a CLOB.

    DB2 is having a field with varchar(32700).When this is imported to ORacle with a field CLOB it gives problems.THe field is having lots of HTML tags .

    Can any one help me in this.It is just one table.

    Thank
    micky

Posting Permissions

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