Jump to content

Vivi

Members
  • Content count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Vivi

  • Rank
    Newbie
  1. Vivi

    Table Partitioning in oracle 11g

    Hello sir, here i am creating a new table as Table 1,please check the query and please give your suggestions.I am also getting an error while executing this and this is the error that got while executing the following query. Error starting at line : 1 in command - create table new table AS (SELECT * from Table 1) PARTITION BY RANGE (TXN_DATE) ( PARTITION test_p1 VALUES LESS THAN (TO_DATE('01-DEC-2016','dd-MON-yyyy')) TABLESPACE testpartition , PARTITION test_p2 VALUES LESS THAN (TO_DATE('01-APR-2017','dd-MON-yyyy')) TABLESPACE testpartition1 , PARTITION test_p3 VALUES LESS THAN (TO_DATE('01-OCT-2017','dd-MON-yyyy')) TABLESPACE testpartition2 , PARTITION test_p4 VALUES LESS THAN (TO_DATE('01-APR-2018','dd-MON-yyyy')) TABLESPACE testpartition3 , PARTITION test_p5 VALUES LESS THAN (TO_DATE('01-OCT-2018','dd-MON-yyyy')) TABLESPACE testpartition4 ) Error at Command Line : 4 Column : 1 Error report - SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause: *Action: ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- query as follows : create table new table AS (SELECT * from Table 1 ) PARTITION BY RANGE (TXN_DATE) ( PARTITION test_p1 VALUES LESS THAN (TO_DATE('01-DEC-2016','dd-MON-yyyy')) TABLESPACE testpartition , PARTITION test_p2 VALUES LESS THAN (TO_DATE('01-APR-2017','dd-MON-yyyy')) TABLESPACE testpartition1 , PARTITION test_p3 VALUES LESS THAN (TO_DATE('01-OCT-2017','dd-MON-yyyy')) TABLESPACE testpartition2 , PARTITION test_p4 VALUES LESS THAN (TO_DATE('01-APR-2018','dd-MON-yyyy')) TABLESPACE testpartition3 , PARTITION test_p5 VALUES LESS THAN (TO_DATE('01-OCT-2018','dd-MON-yyyy')) TABLESPACE testpartition4 );
  2. Vivi

    Table Partitioning in oracle 11g

    Thanks for the reply.....i'll go through it and update you soon...
  3. Hello, I got a task to partition the existing table in an Oracle database 11g,I want to convert a non partitioned table to partition table based on range partition.So please share your valuable tips and suggestions.
×