GRANT

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 Revoke All Privileges from User

by Ed Chen
December 2, 2022March 12, 2023

The Principle of Least Privilege At times, you see plenty of unnecessary privileges on user, this is because some privileged user accidentally granted nearly all… Read More »

How to Resolve ORA-01418: specified index does not exist

by Ed Chen
September 30, 2022December 23, 2022

ORA-01418 Tried to alter an index, but it failed with ORA-01418. SQL> alter index emp_emp_id_pk rebuild; alter index emp_emp_id_pk rebuild * ERROR at line 1:… Read More »

How to Resolve PLS-00753: malformed or corrupted wrapped unit

by Ed Chen
August 3, 2022September 7, 2022

PLS-00753 Found a compile error PLS-00753 when we compiled trigger CAT_ROLLBACK_TRIGGER owned by GSMADMIN_INTERNAL. PLS-00753: malformed or corrupted wrapped unit Finally, we found that some… Read More »

How to Resolve PLS-00201: identifier 'DBMS_SQL' must be declared

by Ed Chen
June 21, 2022June 29, 2022
2 Comments

PLS-00201 We have talked about some common patterns of PLS-00201. Here is another case. Found some packages of CTXSYS are invalid, most compile errors are… Read More »

Oracle Grant Privilege Correctly

by Ed Chen
June 18, 2022March 20, 2023

Granting vs Revoking Granting a valid privilege to a grantee is easy and can be repeated over and over again, even though the privilege has… Read More »

How to Resolve ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

by Ed Chen
April 13, 2022April 20, 2022

ORA-01035 Tried to connect to a database in restricted mode, but it failed with ORA-01035. C:\Users\ed>sqlplus hr/hr@ORCL ... ERROR: ORA-01035: ORACLE only available to users… 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 »