Alter table move - add physical attribute clause for indexes
Hi,
I want to move a table and its indexes to another tablespace (12.2) e.g.
ALTER TABLE ttest MOVE ONLINE TABLESPACE tablets LOGGING PARALLEL (DEGREE 8) UPDATE INDEXES ( TEST_I TABLESPACE index_ts );
How can I add a physical_attributes_clause e.g. pctfree,initrans for the indexes?
I can add a segment_attributes_clause ( TEST_I TABLESPACE index_ts ) but adding a physical_attributes_clause should also be possible.
I couldn't find an example and my tests were not successful.
thx