i have a table which is compressed on some partitons,
which i have to uncompress for the reason of dropping an unused column
when i tried the below syntax,
alter table table_name move nocompress;
the error it is showing is,
Error report -
SQL Error: ORA-14511: cannot perform operation on a partitioned object
14511. 00000 - "cannot perform operation on a partitioned object"
*Cause: An attempt was made to perform an operation that is not allowed
on partitioned tables or indexes.
*Action: Retry the command with correct syntax.
can we uncompress a range partitioned table?