2 Replies Latest reply: Sep 19, 2012 9:42 AM by Pnauduri-Oracle RSS

    what is SQLDEVELOPER_CLOB_7

    947771
      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
          Pnauduri-Oracle
          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
            Pnauduri-Oracle
            You can read a blog entry on this topic here: http://dermotoneill.blogspot.com/2012/01/sybase-and-sql-server-image-data-move.html