This content has been marked as final. Show 2 replies
SHRINK SPACE Clause
This clause is valid only for temporary tablespaces. It lets you reduce the amount of space the tablespace is taking. In the optional KEEP clause, the size_clause defines the lower bound that a tablespace can be shrunk to. It is the opposite of MAXSIZE for an autoextensible tablespace. If you omit the KEEP clause, then the database will attempt to shrink the tablespace as much as possible as long as other tablespace storage attributes are satisfied.
If this holds true then you are looking at a bug.
sir i have checked shrink with keep statement on another server but it behavior is same i issue following command
alter tablespace temp shrink space keep 40m
but after shrink i saw the 4 files shrink and strangly their size is 2mb instead 40m. if i omit keep statement it also shrink the size to 2mb. and one tempfile remain as it why it also shrink 4 files
i think shrink temfile also possible but not sure becoz it never run successfully