Skip to Main Content

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!

need to uncompress a hash partitioned table

731838Jun 14 2010 — edited Jun 14 2010
I am working on oracle 11.1.0.7 database on solaris.

We had issues loading data into compressed tables, so we are trying to uncompress the tables and their partitions.
When I tried uncompressing a hash partitioned table, I am getting this error

SQL> alter table sample move partition SYS_1 nocompress;
alter table sample move partition SYS_1 nocompress
*
ERROR at line 1:
ORA-14260: incorrect physical attribute specified for this partition

I am able to move the table, it is just the nocompress option which doesn;t work.

SQL> alter table sample move partition SYS_1;

Table altered.

Can't we uncompress a hash partitioned table which is compressed?
This post has been answered by MaximDemenko on Jun 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2010
Added on Jun 14 2010
2 comments
4,199 views