ORA-00904: invalid identifier



Share this article :

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 #.

Related posts

Start & Stop Oracle Database in UNIX/Linux
V$INSTANCE: Display Oracle Database & Instance State
Find Total Number of Records from a Table in Oracle
ORA-02095: specified initialization parameter cannot be modified
© 2018 ITsiti. All Rights Reserved
Powered by KEEM