ORA-00904: invalid identifier

You are executing an Oracle command but getting error as below,

SQL> select tablspace_name from dba_tablespaces where status ='OFFLINE';

select tablspace_name from dba_tablespaces where status ='OFFLINE'
       *
ERROR at line 1:
ORA-00904: "TABLSPACE_NAME": invalid identifier

Cause

The column name entered is either missing or invalid.

Solution

Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #.