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

Oracle Database Begin & End Backup
V$ARCHIVED_LOG: Archived Log Information from Control File
Find the Location of Oracle SPFILE
How to Start & Stop Oracle iSQL*Plus
© 2017 ITsiti. All Rights Reserved
Powered by KEEM