Database Administration (MOSC)

MOSC Banner

ORA-14099 with 11g interval range partition exchange

edited Jun 22, 2009 3:33AM in Database Administration (MOSC) 1 comment
4th attempt at posting this - oh for the old site, proof that new and shiny is not always better ...
OS is Linux kernal version  2.6.16.13-4-smp #1 SMP x86_64 GNU/Linux

Oracle version is :

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

I am trying to 11g range interval partitioning for use in a archiving strategy which will move all data from a few tables to a corresponding partitioned tables on a weekly basis.

I have set up a test case which demonstrates the problem I am having.

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