2 Replies Latest reply on Nov 9, 2018 9:54 PM by Timo Hahn

    Automatic Partition Table

    3718142

      Hello Team,

       

      I have oracle application version R12.2 and having oracle 12c database. I am trying to create custom table with Automatic partition but I am getting following error:

       

      CREATE TABLE XXBNS.XXBNS_FAH_PERU_INTER

      (ORIGINATOR VARCHAR2(40 BYTE) NOT NULL,

      SRC_ORIGIN VARCHAR2(10),

      SRC_BATCH_ID NUMBER,

      SRC_TRANSACTION_ID NUMBER NOT NULL,

      EVENT_CLASS VARCHAR2(50 BYTE),

      EVENT_TYPE_CODE VARCHAR2(50 BYTE),

      ENTITY_CODE VARCHAR2(50 BYTE),

      EVENT_REQUEST_ID NUMBER,

      EVENT_ID NUMBER,

      EVENT_STATUS_CODE VARCHAR2(20 BYTE),

      SRC_ACT_TYPE    VARCHAR2(5),

      FAH_TRX_NUMBER NUMBER,

      LINE_NUMBER NUMBER,

      CONVERSION_DATE DATE,

      CONVERSION_RATE NUMBER,

      CONVERSION_RATE_TYPE VARCHAR2(10 BYTE),

      ACCOUNTING_DATE DATE,

      ORACLE_PROCESS_STATUS VARCHAR2(30 BYTE),

      ORACLE_PROCESS_DATE DATE,

      ORACLE_REPROCESS_FLAG VARCHAR2(3 BYTE),

      ARCH_DT_STAMP_REQUEST_ID NUMBER,

      ARCHIVE_READY_DATE DATE,

      REQUEST_ID NUMBER,

      CREATED_BY VARCHAR2(40 BYTE),

      CREATION_DATE DATE,

      LAST_UPDATE_DATE DATE,

      LAST_UPDATED_BY VARCHAR2(40 BYTE),

      SRC_DR_CR VARCHAR2(5 BYTE),

      SRC_DEBIT_AMOUNT NUMBER,

      SRC_CREDIT_AMOUNT NUMBER,

      SRC_CURRENCY VARCHAR2(5 BYTE),

      SRC_ENTERED_DEBIT_AMOUNT NUMBER,

      SRC_ENTERED_CREDIT_AMOUNT NUMBER,

      SRC_ENTERED_CURRENCY VARCHAR2(5),

      SRC_ACCOUNTED_DEBIT_AMOUNT NUMBER,

      SRC_ACCOUNTED_CREDIT_AMOUNT NUMBER,

      SRC_ACCOUNTED_CURRENCY VARCHAR2(5),

      TREATMENT1 NUMBER,

      TREATMENT2 NUMBER,

      TREATMENT3 NUMBER,

      TREATMENT4 NUMBER,

      TREATMENT5 NUMBER,

      SRC_TRANSIT VARCHAR2(10),

      SRC_LOCACCT VARCHAR2(50),

      SRC_INEAACCT VARCHAR2(50),

      SRC_EGLACCT VARCHAR2(50),

      SRC_DEPT VARCHAR2(50),

      SRC_PRODUCT VARCHAR2(50),

      SRC_CUSTSEG VARCHAR2(50),

      SRC_ACCTCOMB VARCHAR2(50),

      ATTRIUBUTE1 VARCHAR2(150 BYTE),

      ATTRIUBUTE2 VARCHAR2(150 BYTE),

      ATTRIUBUTE3 VARCHAR2(150 BYTE),

      ATTRIUBUTE4 VARCHAR2(150 BYTE),

      ATTRIUBUTE5 VARCHAR2(150 BYTE),

      LEDGER_ID NUMBER,

      DESCRIPTION VARCHAR2(250 BYTE),

      ERROR_TYPE VARCHAR2(10),

      ERROR_REASON VARCHAR2(2000),

      CONSTRAINT BNS_FAH_PERU_PK Primary key(SRC_TRANSACTION_ID)

      )

      PARTITION BY LIST (ORIGINATOR) automatic

      (

        PARTITION p_SBP VALUES('SBP_BAL','SBP_TRN')

      );

       

       

      Error:

       

      rror report -

      ORA-00922: missing or invalid option

      00922. 00000 -  "missing or invalid option"

      *Cause:   

      *Action: