ALL_OBJECTS

How to Resolve ORA-08186: invalid timestamp specified

by Ed Chen
March 17, 2023March 21, 2023

ORA-08186 Tried to perform a flashback query, but it failed with ORA-08186. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('3023-02-20 00:53:08', 'yyyy-mm-dd hh24:mi:ss');… Read More »

How to Resolve ORA-01466: unable to read data - table definition has changed

by Ed Chen
March 16, 2023March 21, 2023

ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »

How to Resolve ORA-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022April 9, 2022

ORA-02030 Tried to grant SELECT object privilege to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant select on… Read More »

LAST_DDL_TIME, How and Why

by Ed Chen
March 11, 2022March 21, 2023

LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… Read More »

How to Check Oracle Table Creation Date

by Ed Chen
June 23, 2021June 2, 2022

We usually retrieve table information from ALL_TABLES, but it has no table creation date. This is because table is also an object type, so we… Read More »