Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I have been a grateful member of this site for several years. I love this site and refer everyone to it!..."

Geography

Where in the world do Tek-Tips members come from?

Porblem adding partition to index organized table

GremlinHunter (Programmer)
10 Aug 07 12:14
  I am hoping someone here has an idea on this.  We have a number of tables that are index organized tables.  Every day as part of a job new partitions are created for several days from now.  

  Problem is that yesterday did not get any partitions created for it but partitions have been created for today and the next several days.  As a result I can not just add in the missing partitions due to a ORA-14074 error.

  I think I can just rename the partitions to fill the gaps then run a split clause to put the data in the correct partitions but I am not sure...  Anyone delt with this before?
Dagon (MIS)
13 Aug 07 6:29
You will probably need to do an "alter table ..split partition" instead.
GremlinHunter (Programmer)
13 Aug 07 8:27
  So I gather.  When I posted this I was under the impression that split did not create a new partition but redistributed data between existing ones.  I know a little better now.  At this point in time I am trying to work out how much data is too much to split.  I am not keen on creating temp tables for 40+ tables to split an empty partition.  

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close