This discussion is archived
2 Replies Latest reply: Sep 19, 2012 7:42 AM by 84959 RSS

what is SQLDEVELOPER_CLOB_7

947771 Newbie
Currently Being Moderated
Hi!

( wanted to changed the category so i asked the question again.)

while migrating from sqlserver 2005 to oracle 11g r2 xe it is creating extra cols like

SQLDEVELOPER_CLOB_7 for each blob column which is getting created for image col in sqlserver .

what are they?
can i delete it, as i do not need them.

yours sincerely

Edited by: 944768 on Sep 18, 2012 12:52 AM

Edited by: 944768 on Sep 18, 2012 3:39 AM
  • 1. Re: what is SQLDEVELOPER_CLOB_7
    84959 Explorer
    Currently Being Moderated
    As confirmed by SQLDeveloper development team, Here is some information on this:

    When migrating SQL Server/Sybase IMAGES to Oracle in 'offline' mode, we cant upload the data using SQL Loader directly into the BLOB column because:

    1. IMAGEs in SQL Server/Sybase dumped out in HEX.
    2. Oracle s HEXTORAW function can only take 4000 chars
    3. So data gets uploaded in chunks against the CLOB
    4. Then a procedure is run with HEXTORAW to convert it to BLOB
    5. After the data load is over, this additional CLOB column can be dropped from the table as Oracle allows you to drop a column.

    All this happens in automated fashion for offline data load process. For On-line data move, this is not required.

    Hope this helps

    Prakash
  • 2. Re: what is SQLDEVELOPER_CLOB_7
    84959 Explorer
    Currently Being Moderated
    You can read a blog entry on this topic here: http://dermotoneill.blogspot.com/2012/01/sybase-and-sql-server-image-data-move.html

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points