Compress lob subpartition
Date: Fri, 21 May 2021 18:40:12 +1000
Message-ID: <CAJEEaCxd9L+NSb_h1vF_h9ZWtzk1Dz26u4xo=81kdazqfqEqJg_at_mail.gmail.com>
Hi all,
I have a table which is interval partitioned and has lob subpartitions.
(Table definition attached)
Is there a way to move and HCC the lob subpartitions
- Move for non-lobs and compress works
ALTER TABLE show_lob_storage MOVE SUBPARTITION SYS_SUBP2116124 TABLESPACE pds_data COMPRESS FOR ARCHIVE HIGH ONLINE;
Table SHOW_LOB_STORAGE altered.
- Move without compression works
alter table show_lob_storage move subpartition SYS_SUBP2116124 lob
(additionalinformation) store as securefile (tablespace pds_data) online;
Table SHOW_LOB_STORAGE altered.
- Move for LOBS and compress does not seem to work
SQL> alter table show_lob_storage move subpartition SYS_SUBP2116124 lob
(additionalinformation) compress high online;
alter table show_lob_storage move subpartition SYS_SUBP2116124 lob
(additionalinformation) compress high online
*
ERROR at line 1:
ORA-00905: missing keyword
SQL> alter table show_lob_storage move subpartition SYS_SUBP2116124 lob
(additionalinformation) store as securefile (tablespace pds_data) compress
high online;
alter table show_lob_storage move subpartition SYS_SUBP2116124 lob
(additionalinformation) store as securefile (tablespace pds_data) compress
high online
ERROR at line 1:
ORA-14160: this physical attribute may not be specified for a table
subpartition
-- Fairlie Rego Executive Database Architect www.technoconsulting.com.au http://www.linkedin.com/in/fairlierego https://fairlierego.wordpress.com/ Twitter _at_fairlieregoReceived on Fri May 21 2021 - 10:40:12 CEST
-- http://www.freelists.org/webpage/oracle-l
- text/plain attachment: compress_lob_subpartion.txt