Database DataWarehousing (MOSC)

MOSC Banner

Altering a table with interval partition from monthly to dailyHi.

edited Jan 27, 2015 10:02AM in Database DataWarehousing (MOSC) 2 commentsAnswered

Hi

I am using oracle 11.2.0.4 and I am considering switching a table from interval monthly partitions to interval daily partitions. I did a quick test on a test table and it seems to be working as expected.

My only concern is  - is doing that (alter table set interval) going to have any negative consequences in terms of administering this table.  I don't see anything, but I wanted to check before we went live with that

TIA

Gene

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