ORA-04023: Object could not be validated or authorized

ORA- Error:


SQL>SELECT DAT.*,DATE_MODE||';'||SYS_META_KEY MIS_XDISPARE
FROM MIS_SYS_DATA DAT WHERE 1 = 0 

ORA-04023: Object could not be validated or authorized

Bermuda Triangle The Mystery Solved ?

What is Bermuda Triangle ?

The Bermuda Triangle, also known as the Devil's Triangle or Hurricane Alley, is a loosely defined region in the western part of the North Atlantic Ocean where a number of aircraft and ships are said to have disappeared under mysterious circumstances.

Where is Bermuda Triangle Located ?

About 500,000 square miles of ocean off the southeastern tip of Florida , In Atlantic Ocean roughly bounded by Miami, Bermuda and Puerto Rico. The total area varying from 1,300,000 to 3,900,000 km (500,000 to 1,510,000 sq mi)."Indeed, some writers even stretch it as far as the Irish coast."

(Graphical Image of Bermuda Triangle)

                                                                                                                            

 (Satellite Image of Bermuda Triangle)

Who found Bermuda Triangle ?

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

ORA- Error :

SQL> truncate table mis_report_new;
truncate table mis_report_new
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

Cause :

ORA-01830: date format picture ends before converting entire input string

ORA- Error :


SQL> SELECT TIMESTAMP ,db_user,OS_USER,object_schema,object_name,policy_name,statement_type,sql_text FROM DBA_FGA_AUDIT_TRAIL where policy_name like 'FGA%' and to_date(TIMESTAMP,'dd-mon-yyyy') >= to_date(sysdate-7,'dd-mon-yyyy') ORDER BY TIMESTAMP; 2 3

FROM DBA_FGA_AUDIT_TRAIL where policy_name like 'FGA%' and to_date(TIMESTAMP,'dd-mon-yyyy') >= to_date(sysdate-7,'dd-mon-yyyy')
*
ERROR at line 2:
ORA-01830: date format picture ends before converting entire input string

ORA-04022: nowait requested, but had to wait to lock dictionary object

ORA- Error:

SQL> exec dbms_fga.drop_policy('APPL_OWNER','MIS_CONDITION','FGA_MIS_CONDITION_SEL');

PL/SQL procedure successfully completed.


SQL> EXECUTE DBMS_FGA.ADD_POLICY(OBJECT_SCHEMA => 'APPL_OWNER',OBJECT_NAME => ', POLICY_NAME => 'FGA_MIS_CONDITION_SEL', AUDIT_CONDITION => 'SYS_CONTEXT(''USERENV'',''SESSION_USER'') IN (''APPL_XE_WRITER'',''APPL_READER'')', AUDIT_COLUMN => 'AGREEMENT_CODE', ENABLE => TRUE, STATEMENT_TYPES => 'SELECT');

BEGIN DBMS_FGA.ADD_POLICY(OBJECT_SCHEMA => 'APPL_OWNER',OBJECT_NAME => 'MIS_CONDITION', POLICY_NAME => 'FGA_MIS_CONDITION_SEL', AUDIT_CONDITION => 'SYS_CONTEXT(''USERENV'',''SESSION_USER'') IN (''APPL_XE_WRITER'',''APPL_READER'')', AUDIT_COLUMN => 'AGREEMENT_CODE', ENABLE => TRUE, STATEMENT_TYPES => 'SELECT'); END;

*
ERROR at line 1:
ORA-04022: nowait requested, but had to wait to lock dictionary object
ORA-06512: at "SYS.DBMS_FGA", line 20
ORA-06512: at line 1