'ORA-00904 invalid identifier' or 'PLS-00201' error for DBMS_LOB
Last Updated June 14, 2017
For any situation that requires LOB tablespace access (new install schema creation, incident modification, etc.), an error occurs pointing to DBMS_LOB as the cause.
One of the following errors will be seen in the appropriate log for the failed situation:
ORA-00904: : invalid identifier
PLS-00201: identifier 'DBMS_LOB' must be declared
Errors to access DBMS_LOB can happen as part of an effort to tighten database security. Because the DBMS_LOB package is owned by sys, DBAs may restrict access to it and other utilities in an effort to reduce hacking risks.
From SQLPLUS (logged in as 'SYS as SYSDBA'), run the following query:
grant execute on dbms_lob to protect;
Imported Document ID: TECH220621
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe