Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Interval Partitioned to Range. Created Daily Partitions from Monthly Part.

user8941550Dec 4 2012 — edited Dec 5 2012
Hi,

We have a huge table with millions of rows.
I need to change it to a Range Partitioned.

CREATE TABLE A
(
a NUMBER,
CreationDate DATE
)
PARTITION BY RANGE (CreationDate)
INTERVAL ( NUMTODSINTERVAL (30, 'DAY') )
(PARTITION P_FIRST
VALUES LESS THAN (TIMESTAMP ' 2001-01-01 00:00:00'))

Now as Table A is Interval Partitioned Monthly as shown above.
WHEREAS Partition Key is DATE.

So when I create the new Range Partitioned Table and use a script we already have to create partitions in advance. It uses the Partition Key as Date and creates Daily Partition.

WHAT are the consequences if I apply daily partitions instead of the monthly ones on this table after converting it to a Range Partitioned table.
Please suggest..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2013
Added on Dec 4 2012
5 comments
2,337 views