Database Administration (MOSC)

MOSC Banner

I want to change the partitioning on a partitioned table. How do I don this?

edited Aug 25, 2014 4:09PM in Database Administration (MOSC) 3 commentsAnswered ✓

I goofed when I created a partitioned table and defined the structure for the partitions

   PARTITION ld_data_012014_p VALUES LESS THAN (TO_DATE('2-1-2014', 'DD-MM-YYYY')) ,

   PARTITION ld_data_022014_p VALUES LESS THAN (TO_DATE('3-1-2014', 'DD-MM-YYYY')) ,...

Used the date format of DD-MM-YYYY but the value less than is expecting MM-DD-YYYY

Millions of rows have been inserted into the table.

What I am thinking of doing is

  creating new partitions on the table

   PARTITION ld_data_012014_p2 VALUES LESS THAN (TO_DATE('2-1-2014', MM-DD-YYYY')) , 

   PARTITION ld_data_022014_p2 VALUES LESS THAN (TO_DATE('3-1-2014', MM-DD-YYYY')) ,...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center