Home » RDBMS Server » Server Administration » how to compress table (11.2.0.1.0 Windos XP)
how to compress table [message #522359] Thu, 08 September 2011 21:16 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
There is a huge table,i want to compress it,how can i do?
alter table tb_my_table compress

After executed the sql,the size of table have any change.

Report message to a moderator

Re: how to compress table [message #522360 is a reply to message #522359] Thu, 08 September 2011 22:18 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
hi andy,

Please check this url :

http://www.oracle-base.com/articles/11g/TableCompressionEnhancements_11gR1.php

Report message to a moderator

Re: how to compress table [message #522470 is a reply to message #522359] Sat, 10 September 2011 01:23 Go to previous message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
It is all explained in the docs,
http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/tables002.htm#ADMIN11630
The behaviour you describe is expected, can you work out what you need to do next?

Andy, you have to start reading things. You will never have a successful career in database administration unless you study and experiment.

Report message to a moderator

Previous Topic: "How to test row movement" & "partition issue" merged
Next Topic: 11.2.0.2.3 GI Patch Set Update
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 04:21:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.