Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> Oracle Syntax Migration (GaussDB A)> SUPPLEMENTAL LOG DATA
View PDF

SUPPLEMENTAL LOG DATA

Additional columns can be logged in the redo log files. The process of logging these additional columns is called supplemental logging. This feature is supported by Oracle and this is not available in Gauss.

Input

CREATE TABLE sad.fnd_lookup_values_t
           (
   lookup_code_id NUMBER NOT NULL /* ENABLE */
   ,lookup_code VARCHAR2 (40) NOT NULL /* ENABLE */
   ,meaning       VARCHAR2 (100) 
   ,other_meaning VARCHAR2 (100) 
   ,order_by_no   NUMBER 
   ,start_time    DATE DEFAULT SYSDATE NOT NULL /* ENABLE */
   ,end_time    DATE 
   ,enable_flag CHAR( 1 ) DEFAULT 'Y' NOT NULL /* ENABLE */
   ,disable_date DATE 
   ,created_by   NUMBER ( 15 ,0 ) 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 ) DEFAULT 0 NOT NULL /* ENABLE */
   ,description    VARCHAR2 (500) 
   ,lookup_type_id NUMBER NOT NULL/* ENABLE */
   ,attribute4 VARCHAR2 (250) 
   ,supplemental log data (ALL) COLUMNS
   ) ;

Output

CREATE TABLE sad.fnd_lookup_values_t
           (
   lookup_code_id NUMBER NOT NULL /* ENABLE */
   ,lookup_code VARCHAR2 (40) NOT NULL /* ENABLE */
   ,meaning       VARCHAR2 (100) 
   ,other_meaning VARCHAR2 (100) 
   ,order_by_no   NUMBER 
   ,start_time    DATE DEFAULT SYSDATE NOT NULL /* ENABLE */
   ,end_time    DATE 
   ,enable_flag CHAR( 1 ) DEFAULT 'Y' NOT NULL /* ENABLE */
   ,disable_date DATE 
   ,created_by   NUMBER ( 15 ,0 ) 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 ) DEFAULT 0 NOT NULL /* ENABLE */
   ,description    VARCHAR2 (500) 
   ,lookup_type_id NUMBER NOT NULL/* ENABLE */
   ,attribute4 VARCHAR2 (250) 
   /* ,supplemental log data (ALL) COLUMNS */
   ) ;

SUPPLEMENTAL LOG DATA that is not supported by Gauss need to be commented out.

"SUPPLEMENTAL LOG DATA" in Table creation not supported. So, Supplemental Log Data should be commented .

Input

 CREATE TABLE SAD.FND_DATA_CHANGE_LOGS_T
   (    LOGID NUMBER,
        TABLE_NAME VARCHAR2(40) NOT NULL ENABLE,
        TABLE_KEY_COLUMNS VARCHAR2(200),
        TABLE_KEY_VALUES VARCHAR2(200),
        COLUMN_NAME VARCHAR2(40) NOT NULL ENABLE,
        COLUMN_CHANGE_FROM_VALUE VARCHAR2(200),
        COLUMN_CHANGE_TO_VALUE VARCHAR2(200),
        DESCRIPTION VARCHAR2(500),
         SUPPLEMENTAL LOG DATA (ALL) COLUMNS
   );

Output

CREATE TABLE sad.fnd_data_change_logs_t 
  ( 
     logid                    NUMBER 
     ,table_name               VARCHAR2 (40) NOT NULL /* ENABLE */ 
     ,table_key_columns        VARCHAR2 (200)
     ,table_key_values         VARCHAR2 (200) 
     ,column_name              VARCHAR2 (40) NOT NULL /* ENABLE */ 
     ,column_change_from_value VARCHAR2 (200)
     ,column_change_to_value   VARCHAR2 (200) 
     ,description              VARCHAR2 (500) 
     /*, SUPPLEMENTAL LOG DATA (ALL) COLUMNS*/ 
  )