Database Administration (MOSC)

MOSC Banner

TABLE PARTITIONING

edited Oct 28, 2013 7:45AM in Database Administration (MOSC) 4 commentsAnswered
Hello everyone

I am new at partitioning and i would like some advice from the comunity.

I have a big jdedwards table it is called F4111 when i look at the table i see that the table has been partitioned by month up until may of the current year but then there is one partition that has been created with values less than 2032-03-01

so all the data from now on up until 2032-03-01 will be inserted on the same partition, we have foud that this is due to a user error inputting the incorrect date instead of 2013 the year has been inserted as 2032.

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