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

sqlplus: Command not found
ORA-28000: the account is locked
ORA-27101: shared memory realm does not exist
ORA-01012: not logged on
© 2017 ITsiti. All Rights Reserved
Powered by KEEM