Database Administration (MOSC)

MOSC Banner

shrinking a partitionned table

edited May 14, 2010 2:56AM in Database Administration (MOSC) 3 commentsAnswered
 Hello , I am trying to shrink a partitioned table :

alter table myOwner.myTable enable row movement;
is ok

alter table myOwner.myTable modify partition myPartition shrink space;
give this error :
Erreur SQL : ORA-10631: SHRINK clause should not be specified for this object
10631. 00000 -  "SHRINK clause should not be specified for this object"
*Cause:    It is incorrect to issue shrink on the object
*Action:   Verify the object name and type and reissue the command

i do not see what's wrong...

thanks

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