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;
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