Oracle Error ORA-02152: Invalid ALTER TABLESPACE … RENAME option

Oracle Error Message

ORA-02152: Invalid ALTER TABLESPACE … RENAME option

Reason for the Error

An option other than DATAFILE or TO follows by ALTER TABLESPACE … RENAME.

Solution

The user must specify either DATAFILE or TO following ALTER TABLESPACE … RENAME.