Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5237

Oracle unparsable ddl create table

XMLWordPrintable

      see attached log for full error

      oracleparseerr.txt

      CREATE TABLE "APPLSYS"."FND_SEC_GUIDELINES_TL" 
         (    "CODE" VARCHAR2(20) NOT NULL ENABLE, 
          "TITLE" VARCHAR2(100) NOT NULL ENABLE, 
          "DESCRIPTION" VARCHAR2(2000) NOT NULL ENABLE, 
          "INFO" CLOB NOT NULL ENABLE, 
          "LANGUAGE" VARCHAR2(30) NOT NULL ENABLE, 
          "SOURCE_LANG" VARCHAR2(4) NOT NULL ENABLE, 
          "CREATED_BY" VARCHAR2(30) NOT NULL ENABLE, 
          "CREATION_DATE" DATE NOT NULL ENABLE, 
          "LAST_UPDATED_BY" NUMBER(15,0) NOT NULL ENABLE, 
          "LAST_UPDATE_DATE" DATE NOT NULL ENABLE, 
          "LAST_UPDATE_LOGIN" NUMBER(15,0)
         ) PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 LOGGING
        STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
        PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
        TABLESPACE "APPS_TS_TX_DATA" 
       LOB ("INFO") STORE AS (
        TABLESPACE "APPS_TS_TX_DATA" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
        NOCACHE 
        STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
        PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)) 
      ; 

       

      cc: ccranfor@redhat.com anmohant 

            ccranfor@redhat.com Chris Cranford
            tooptoop toop toop (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: