Tuesday, 3 January 2017

Shrink Temporary Tablespace in 11G

In Pre 11g oracle versions if we would shrink the temporary table space we need to resize the temp data file to required size but In 11g you have option to Shrink temporary table space and/or temp file Instead of Resize the Temp table space or temp file.


ALTER TABLEPSACE TEMP SHRINK SPACE;

or

ALTER TABLESPACE temp shrink space keep 100m;

or 

ALTER TABLESPACE TEMP SHRINK TEMPFILE '................' KEEP 250M;

No comments:

Post a Comment