Hi all,
how can i shrink the space used by tablespaces, I have some table reaching to 99% used and want to shrink it.
how can i make it automated job to shrink if the usage is more than 70%?
Please help and guide!!
thanks
Pat
Printable View
Hi all,
how can i shrink the space used by tablespaces, I have some table reaching to 99% used and want to shrink it.
how can i make it automated job to shrink if the usage is more than 70%?
Please help and guide!!
thanks
Pat
Log into your database as sys using sqlplus and run the following file. It will let you know the high water mark of each tablespace and the largest free extent.This should help you to decide if you can shrink your database.
But before you start shrinking things, you try to do some basic reading to get a better understanding of space management in Oracle.
Unplanned shrinkage is usually bad!!! :D
and how do you intend to shrink it if the space is used?Quote:
Originally Posted by midora