Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Partitioning an Existing Table using DBMS_REDEFINITION - This article presents a simple method for partitioning an existing table using the DBMS_REDEFINITION package.



Daniel said...

Just to say hellow!

Shahid Farooq said...

It is good article, I suggest to complete this article by adding other features like split, merge and delete partitions examples.

Rakesh Verma said...

Good article

JB said...

excellent article, now i have to try on the real table

Derek said...

Thanks for this, exactly what I'm needing to do for our prod databases. Very useful!

Sachin said...

hi,

I can say only one word " WOW"

Thanks a lot ..

Jeff said...

Exactly what I was looking for. Complete and concise. Thanks.

Manjit Kumar said...

Precise & to the point writing
Regards

Peter said...

One quirk - you need to recompile all objects referencing 'BIG_TABLE', e.g. with utl_recomp

Aryan said...

One query - Can the dbms_redefinition package be used for tables having no Primary Keys.

What will happen to the db_links do we need to create them.If Yes then at what point?

(Provided I'm using Oracle 9i Database)

Cheers
Aryan

Adarsh Kumar DBA said...

Nice Article , I think Adding Index before the synch is good idea because if you synch before and Add index later the Index may take longer time to build and table will again be out of synch

Thanks

Mike Alex, said...

very Nice article
Thanks
Mike

Tim... said...

Building an index on a full table is usually quicker than doing index maintenance while building a table.

Each to their own. :)

Cheers

Tim...

Debbie Sams said...

It's a great article but I don't know if I can use the info since it doesn't reference a particular Oracle version and it isn't even dated, nor are the comments ????

Tim... said...

Hi.

This method has been available since Oracle 9i. Of course, the simple solution to your question would have been to run the same code. It would have taken you 2 minutes.

Cheers

Tim...

joe skinner said...

This is one of the best things I have run across in 12 years of being a DBA. Very nice indeed. Would be interested in something changing a hash partitioned table to list partitioned table.
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired