Unable to migrate sql server CLOBs To Oracle (Doc ID 1253285.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle SQL Developer - Version 2.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 16-Aug-2012***

Symptoms


Sql developer migration workbench. Migrating sql server 2005 to Oracle .

The convert to oracle model fails for clob conversion
The clob data is not very huge in size. It is less than 1000 Bytes and in some cases it is null. So how tp get around the null data issue and will it work if some default string for the column is mentioned in the oracle table.

Following is the example of the table which gets converted to oracle successfully. But data move fails and it gives a wrong error message saying invalid colum successfully run.
All tables with clob columns fail during data move.
CREATE TABLE RADIUS_QA.WEBSVCRUN
(
WEBSVCRUNID NUMBER(20) NOT NULL,
IPADDRESS VARCHAR2(30 BYTE) DEFAULT (''),
RUNTYPE VARCHAR2(50 BYTE) DEFAULT (''),
RUNSTART DATE DEFAULT sysdate NOT NULL,
RUNEND DATE,
SUCCESSFULLRUN NUMBER(1) DEFAULT ((1)) NOT NULL,
CREATEDBY NUMBER(10) DEFAULT ((1)) NOT NULL,
CREATEDON DATE DEFAULT sysdate NOT NULL,
MODIFIEDBY NUMBER(10) DEFAULT ((1)) NOT NULL,
MODIFIEDON DATE DEFAULT sysdate NOT NULL,
ERRORMESSAGE VARCHAR2(4000 BYTE) DEFAULT (''),
STAMP TIMESTAMP(6) DEFAULT sysdate NOT NULL
)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms