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;
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
Post a Comment