0 Replies Latest reply on Nov 5, 2015 2:39 PM by user4295847

    Create Automatic Table Range Partition For Number Column Type For Date Value

    user4295847

      Please share the code for Create Automatic Partition For Number Column Type . For Example ( sales_dt_key column data will be 20150525 ) .

      If I use the below code getting the error,  

       

      Code :

      ---------

       

      create table sales

      (

        sales_id number,

      sales_dt_key number

      )

      partition by range (sales_dt)

      interval (numtoyminterval(1,'MONTH'))

      (

        partition p0701 values less than (to_date('2007-02-01','yyyy-mm-dd'))

      );