Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

DBMS_REDEFINITION to redefine all the partitions of a table

edited Mar 25, 2019 5:03AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 2 commentsAnswered ✓

Hi there.

I've found Doc ID 795893.1 which explains how to redefine a single partition of a table.

In my case, we need to redefine all the partitions of a table, including local and global indexes. And we need to do it online.

So, my simple question here is: Does anyone have an example of how to do it?

We need to perform it over 103 partitions on a pre-production environment. So we need to know if the method on that Doc ID just needs to be replicated all those times

Tagged:

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