Re: create partition oracle

Posted by Roshan on May 04, 2017; 6:25am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/create-partition-oracle-tp2629p2634.html

Hi Erman,

I managed to create the new partition monthly.

As example:


  CREATE TABLE "ARCHICOM"."INTERVAL_TAB"
   ( "ID" NUMBER,
        "CODE" VARCHAR2(10 BYTE),
        "DESCRIPTION" VARCHAR2(50 BYTE),
        "CREATED_DATE" DATE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"
  PARTITION BY RANGE ("CREATED_DATE") INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
 (PARTITION "PART_02"  VALUES LESS THAN (TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(partitionmobile_data.txt
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ) ;


I have a table mobile_data. I have to insert the partition command shown above(bold) and recreate the table. The sql is attached.
Can you please help plugging it. I am getting error in red.
partitionmobile_data.rar

Thanks