Oracle Error Message
ORA-12916: cannot shrink permanent or dictionary managed tablespace
Reason for the Error
An attempt was made to shrink a permanent tablespace or a dictionary managed tablespace.
Solution
Check the tablespace type and issue the statement only on locally managed temporary tablespaces.