Shrink temp space

I an never remember the syntax for this - here's a reminder for the next time i need it......

is it alter system/alter database do you need tablespace/tempfile

do you need size specified.....etc

this does everything you need and is actually quite simple - just need to remember the syntax now...

alter tablespace temp shrink space;

Comments