Solved

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

Posted on 2008-09-29
6
3,062 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 22602867
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
ID: 22603442
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
ID: 22606753
i was dropped rawtxn_200710, rawtxn_200711, rawtxn_200712
0
 
LVL 7

Expert Comment

by:grzessio
ID: 22606831
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
ID: 22606837
try it in order that I gave you.
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

691 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