Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we compress partition table.

290029Nov 22 2005 — edited Nov 22 2005

Hi Oracle Guru,

I have a date range partition table and I try to compress it with
alter table TEST_PAR
move compress;
and I got
ERROR at line 1:
ORA-14511: cannot perform operation on a partitioned object.

Can we compress partition table?

Ideally I would like to compress some of the partition.

How to do it ?

Thanks
Andrew

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2005

Added on Nov 22 2005

#general-database-discussions

3 comments

358 views