ORA-38479: creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed

Cause : The cerationo f sysetm trigger EXFPIL_RETSRICT_YTPEEVOVLE faield duet o misisng Exrpessio nFilte rdictinoary tbales.

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

Try ac lean nistalltaion aagin. I fthis reror i signorde, theu ser wlil be bale toe volveA DTs associatde witht he atrtibutes et, tuhs cauisng spruious rerors.

update : 29-04-2017
ORA-38479

ORA-38479 - creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed
ORA-38479 - creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed

  • ora-28363 : buffer provided not large enough for output
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-08311 : sllfop: bad value for maxrecsize
  • ora-19033 : schema specified in the XML document does not match the schema parameter
  • ora-07494 : scgcm: unexpected error.
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-13142 : invalid PROXIMITY window definition
  • ora-21503 : program terminated by fatal error
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-22861 : invalid user-defined type
  • ora-19647 : non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
  • ora-06731 : TLI Driver: cannot alloc t_call
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-10371 : disable TQ hint
  • ora-07259 : spdcr: exec error, detached process failed in startup.
  • ora-19268 : XQ0048 - namespace string does not match target namespace string
  • ora-06256 : NETNTT: remote fork failed
  • ora-31110 : Action failed as resource string is locked by name
  • ora-31428 : no publication contains all the specified columns
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-02405 : invalid sql plan object provided
  • ora-27432 : step string does not exist for chain string.string
  • ora-16256 : Failure to complete standby redo logfile archival after failover
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-02058 : no prepared transaction found with ID string
  • ora-19648 : datafile string: incremental-start SCN equals checkpoint SCN
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-06251 : NETNTT: cannot translate address file name
  • ora-19922 : there is no parent row with id string and level string
  • ora-28505 : cannot get non-Oracle system capabilities from string
  • 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.