Search notes:

ORA-01747: invalid user.table.column, table.column, or column specification

create table tq84_t(a number, b number);


update
   tq84_t
set
   a = 1,      -- Note the comma
where
   b=2
;


update
   tq84_t
set
   option = 7  -- option is a keyword, see v$reserved_words
where
   b=2
;


select
   t..a        -- Note the double-dot
from
   tq84_t t
Where
   t.b  = 42
;


select
   count(t.*)  -- Note the alias in the aggregate function
from
  tq84_t t;
v$tempseg_usage has a column with the reserved name USER, thus, the following query throws ORA-01747: invalid user.table.column, table.column, or column specification:
select tus.USER from v$tempseg_usage tus;
With the reserved word quoted, the query runs ok:
select tus."USER" from v$tempseg_usage tus;

See also

With Oracle's «improved error messages», Oracle throws ORA-03050: invalid identifier: is a reserved word
Other Oracle error messages

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759429850, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-01747_invalid-user-table-column_table-column-or-column-specification(78): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78