What is the oracle database table compression statements, does not affect to the operation of the table, just save disk space,

CodePudding user response:

Nothing is fish and bear it all,,,

CodePudding user response:

Alter table table_name move compress, what is the role

CodePudding user response:

The ALTER TABLE TEST ENABLE ROW MOVEMENT;


The ALTER TABLE TEST the SHRINK SPACE;




The ALTER TABLE TEST the SHRINK SPACE CASCADE;

CodePudding user response:

reference 5 floor selling fruit net reply:

ALTER TABLE TEST ENABLE ROW MOVEMENT;


The ALTER TABLE TEST the SHRINK SPACE;




The ALTER TABLE TEST the SHRINK SPACE CASCADE;

can you explain it?

CodePudding user response:

Use table compression to improve performance,

CodePudding user response:

reference 4 floor weixin_42722689 response:

alter table table_name move compress, this is what role

This is moving table space

ALTER TABLE TABLE_NAME COMPRESS;//this is compressed table space

CodePudding user response:

refer to the eighth floor AT152S response:

Quote: refer to 4th floor weixin_42722689 response:

Alter table table_name move compress, this is what role

This is moving table space

ALTER TABLE TABLE_NAME COMPRESS;//this is compressed table space

I want to make the table is mainly physical space smaller, let the disk space is bigger, the database of the disk space is too big