Oracle to SQL import system copy error

[former_member201054]

Hi ,

I am peforming Oracle to SQL migration on windows

ABAP import failed with 3 below errors.

(DB) ERROR: DDL statement failed

(DROP TABLE [ENHHEADER])

DbSlExecute: rc = 103

  (SQL error 3701)

  error message returned by DbSl:

Cannot drop the table 'ENHHEADER', because it does not exist or you do not have permission.

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(   CREATE TABLE "ENHHEADER"       ("ENHNAME" VARCHAR2 (000090)         DEFAULT ' ' NOT NULL,        "VERSION" VARCHAR2 (000003)         DEFAULT ' ' NOT NULL,        "TYPE" VARCHAR2 (000012)         DEFAULT ' ' NOT NULL,        "ENHTOOLTYPE" VARCHAR2 (000030)         DEFAULT ' ' NOT NULL,        "SHORTTEXT_ID" VARCHAR2 (000120)         DEFAULT ' ' NOT NULL,        "DOCU_ID" VARCHAR2 (000120)         DEFAULT ' ' NOT NULL,        "STATE" VARCHAR2 (000012)         DEFAULT ' ' NOT NULL,        "UPGRADE" VARCHAR2 (000003)         DEFAULT ' ' NOT NULL,        "DATA_VERSION" VARCHAR2 (000012)         DEFAULT '0000' NOT NULL,        "DATA" BLOB,        "GENERATED" VARCHAR2 (000003)         DEFAULT ' ' NOT NULL)       PCTFREE 10       PCTUSED 00       INITRANS 001       TABLESPACE &SSEXC&    NOCOMPRESS    STORAGE (INITIAL     0000000016 K                NEXT        0000010240 K                MINEXTENTS  0000000001                MAXEXTENTS  UNLIMITED                PCTINCREASE 0000                FREELISTS   001                FREELIST GROUPS 01)      LOB("DATA") STORE AS SECUREFILE      ( NOCOMPRESS ) )

DbSlExecute: rc = 99

  (SQL error 102)

  error message returned by DbSl:

Incorrect syntax near '10'.

(DB) ERROR: DDL statement failed

(ALTER TABLE [ENHHEADER] DROP CONSTRAINT [ENHHEADER~0])

DbSlExecute: rc = 99

  (SQL error 4902)

  error message returned by DbSl:

2) Cannot drop the table 'FDT_XML_IMPORT', because it does not exist or you do not have permission

3)

Cannot drop the table 'BDSCONT3', because it does not exist or you do not have permission.

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(   CREATE TABLE "BDSCONT3"       ("RELID" VARCHAR2 (000006)         DEFAULT ' ' NOT NULL,        "PHIO_ID" VARCHAR2 (000096)         DEFAULT ' ' NOT NULL,        "SRTF2" NUMBER (000010)         DEFAULT 0 NOT NULL,        "PH_CLASS" VARCHAR2 (000030)         DEFAULT ' ' NOT NULL,        "CLUSTR" NUMBER (000005)         DEFAULT 0 NOT NULL,        "CLUSTD" BLOB)       PCTFREE 10       PCTUSED 00       INITRANS 001       TABLESPACE &APPL1&    NOCOMPRESS    STORAGE (INITIAL     0000000016 K                NEXT        0000010240 K                MINEXTENTS  0000000001                MAXEXTENTS  UNLIMITED                PCTINCREASE 0000                FREELISTS   001                FREELIST GROUPS 01)      LOB("CLUSTD") STORE AS SECUREFILE      ( NOCOMPRESS ) )

DbSlExecute: rc = 99

  (SQL error 102)

  error message returned by DbSl:

Incorrect syntax near '10'.

(DB) ERROR: DDL statement failed

(ALTER TABLE [BDSCONT3] DROP CONSTRAINT [BDSCONT3~0])

DbSlExecute: rc = 99

  (SQL error 4902)

Thanks a ton

[former_member188883]

Hi Daniel,

Check whether this SAP note is useful.

Note 962124 - Syntax error during migration to SQL Server 2005

Regards,

Deepak Kori