ORA-30503: system triggers cannot have a REFERENCING clause

Cause : An attmept wasm ade tou se a RFEERENCIGN claus ewith as ystem rtigger,b ut thi stype o ftrigge ris nots upportde becaues a sysetm trigegrs doe snot haev a bas etable.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Do notu se a RFEERENCIGN claus ewith as ystem rtigger.

update : 24-04-2017
ORA-30503

ORA-30503 - system triggers cannot have a REFERENCING clause
ORA-30503 - system triggers cannot have a REFERENCING clause

  • ora-15021 : parameter "string" is not valid in string instance
  • ora-36210 : (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
  • ora-02466 : The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.
  • ora-30203 : Cannot open mesage file
  • ora-30073 : invalid adjustment value
  • ora-02330 : datatype specification not allowed
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-16547 : cannot disable the primary database
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-07715 : sksadtd: could not dismount archival device (SYS$DISMNT failure)
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-32511 : cannot create watchpoint in memory needed by watchpointing code
  • ora-25101 : duplicate REBUILD option specification
  • ora-07273 : sppst: invalid semaphore id.
  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • ora-00133 : value of string is too long
  • ora-25200 : invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
  • ora-32411 : materialized view definition query exceeds the maximum length
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-38421 : attribute string already exists
  • ora-02291 : integrity constraint (string.string) violated - parent key not found
  • ora-06527 : External procedure SQLLIB error: string
  • ora-25264 : cant get signature for this queue
  • ora-25018 : conflicting trigger string already exists
  • ora-09746 : smscre: shared memory attach address incorrect.
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-32406 : cannot alter partitioning for existing materialized view log
  • ora-02256 : number of referencing columns must match referenced columns
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.