This content has been marked as final. Show 3 replies
"Compacting Storage"Not exactly...
is one of the topic in doc.
it mentions shricking, so i think it means shricking.To make the question more plastic: Do you want to reduce the size (footprint) of your (existing) database files or do you want to store data compressed, so it uses less storage? Of course, you can do both for an existing database, but you haven't told us much about it...
and want to know how to do it in 11g xe, as time was less , and i am new bie.... where compression is one of the more advanced topics... Sorry to say, but reading and understanding the underlying concepts is necessary. Just providing you commands to do this or that might make you do something you may regret afterwards.
Anyway, the [url http://docs.oracle.com/cd/E11882_01/server.112/e25494/toc.htm]11.2 Admin Guide documents:
- [url http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema003.htm#ADMIN11600]Understanding Reclaimable Unused Space
- [url http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables002.htm#ADMIN11630]Consider Using Table Compression
- [url http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces007.htm]Altering and Maintaining Tablespaces
I hope this gives you the pointes you need.