CODEWITHSUNDEEP
oracle-database
Robert
Robert

Reputation: 11

partition in oracle

CREATE TABLE temp_stud as select * from STUD_MAST

PARTITION BY RANGE(ADM_DT)

(

PARTITION temp_stud1 VALUES LESS THAN(TO_DATE('02/01/2000','MM/DD/YYYY')),

PARTITION temp_stud2 VALUES LESS THAN(TO_DATE('03/01/2000','MM/DD/YYYY')),

PARTITION temp_stud3 VALUES LESS THAN(TO_DATE('04/01/2000','MM/DD/YYYY')),

PARTITION temp_stud4 VALUES LESS THAN(TO_DATE('05/01/2000','MM/DD/YYYY'))

);

I am getting a missing left parenthesis error for above table creation can anyone tell me what is the issue in above creation

Note: ADM_DT is a date column with data type char(8) and storing format YYMMDD

Upvotes: 0

Views: 278

Answers (1)

Sachin Padha
Sachin Padha

Reputation: 221

Please use below SQL. The Creation of Partition has be part of Create table.

CREATE TABLE temp_stud   
    PARTITION BY RANGE(ADM_DT)

    (

    PARTITION temp_stud1 VALUES LESS THAN(TO_DATE('02/01/2000','MM/DD/YYYY')),

    PARTITION temp_stud2 VALUES LESS THAN(TO_DATE('03/01/2000','MM/DD/YYYY')),

    PARTITION temp_stud3 VALUES LESS THAN(TO_DATE('04/01/2000','MM/DD/YYYY')),

    PARTITION temp_stud4 VALUES LESS THAN(TO_DATE('05/01/2000','MM/DD/YYYY'))

    )
    as select * from STUD_MAST;

Upvotes: 0

Related Questions