Database DataWarehousing (MOSC)

MOSC Banner

Is there any way we can estimate the "elapsed time" requirement for redefining a partitioned table ?

edited Oct 2, 2012 8:30PM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi All,
My question is simple.
I am knowledgeable about how to perform online redefinition of table .

But I am looking for if there is any way we can estimate in advance how much time it is going to take for redef knowing the table size. 
I dont feel so. But need any clarifications if possible.

Also if there is any Online ways to alter a partitioned table to make it subpartitioned ( other than redef ).

Thanks in advance,
Priya

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