Solved

ORA-14080: partition cannot be split along the specified high bound

Posted on 2008-09-29
6
2,825 Views
Last Modified: 2013-12-21
Experts,

i had accidentally dropped one partition. now i am trying to create partition. i am getting following error.
ERROR at line 1:
ORA-14080: partition cannot be split along the specified high bound

can any one help me to fix this problem.

please find the table script

rawtxn-table-script.txt
0
Comment
Question by:pavan27
  • 3
6 Comments
 
LVL 28

Expert Comment

by:Naveen Kumar
Comment Utility
what is the partition name which you dropped ?

what is the current sql which you are running now in order to recreate the partition ? I mean which sql command is giving the error you posted already.
0
 
LVL 7

Expert Comment

by:grzessio
Comment Utility
you are trying to split wrong partition (probably RAWTXN_MAX)

you have to split "next" partition to the one that you dropped.
eg. if you dropped partition RAWTXN_200802 you have to split partition RAWTXN_200803
if you dropped partiiton RAWTXN_200805 you have to split partition RAWTXN_200806
ALTER TABLE RAWTXN

SPLIT PARTITION RAWTXN_200803

AT (TIMESTAMP'2008-03-01 00:00:00')

INTO (PARTITION RAWTXN_200802, PARTITION RAWTXN_200803)

UPDATE GLOBAL INDEXES;
 

you will probably have to rebuild local indexes on splitted partition.

Open in new window

0
 
LVL 1

Author Comment

by:pavan27
Comment Utility
i was dropped rawtxn_200710, rawtxn_200711, rawtxn_200712
0
 
LVL 7

Expert Comment

by:grzessio
Comment Utility
then try:
ALTER TABLE RAWTXN

SPLIT PARTITION RAWTXN_200801 

AT (TIMESTAMP'2007-11-01 00:00:00')

INTO (PARTITION RAWTXN_200710, PARTITION RAWTXN_200801)

UPDATE GLOBAL INDEXES;
 

ALTER TABLE RAWTXN

SPLIT PARTITION RAWTXN_200801 

AT (TIMESTAMP'2007-12-01 00:00:00')

INTO (PARTITION RAWTXN_200711, PARTITION RAWTXN_200801)

UPDATE GLOBAL INDEXES;
 

ALTER TABLE RAWTXN

SPLIT PARTITION RAWTXN_200801 

AT (TIMESTAMP'2008-01-01 00:00:00')

INTO (PARTITION RAWTXN_200712, PARTITION RAWTXN_200801)

UPDATE GLOBAL INDEXES;

Open in new window

0
 
LVL 7

Accepted Solution

by:
grzessio earned 500 total points
Comment Utility
try it in order that I gave you.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now