Database Administration (MOSC)

MOSC Banner

Alter table move - add physical attribute clause for indexes

edited Jun 18, 2019 5:06AM in Database Administration (MOSC) 9 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center