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 : 26-06-2017
ORA-38479

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

  • ora-16160 : Cannot change protected standby database configuration
  • ora-13797 : invalid SQL Id specified, string
  • ora-12611 : TNS:operation is not portable
  • ora-29837 : insufficient privileges to execute implementation type
  • ora-30180 : argument index is too large
  • ora-12921 : database is not in force logging mode
  • ora-30756 : cannot create column or table of type that contains a supertype attribute
  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-23316 : the masterdef is string
  • ora-02836 : Unable to create temporary key file
  • ora-30936 : Maximum number (string) of 'string' XML node elements exceeded
  • ora-06562 : type of out argument must match type of column or bind variable
  • ora-00301 : error in adding log file 'string' - file cannot be created
  • ora-25145 : allocation policy already specified
  • ora-06136 : NETTCP: error during connection handshake
  • ora-12028 : materialized view type is not supported by master site string
  • ora-27024 : skgfqsbi: sbtinit2 returned error
  • ora-16050 : destination exceeded specified quota size
  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-16020 : less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST
  • ora-06408 : NETCMN: incorrect message format
  • ora-29376 : number of consumer groups string in top-plan string exceeds string
  • ora-09969 : unable to close or remove lock file
  • ora-00314 : log string of thread string, expected sequence# string doesn't match string
  • ora-06419 : NETCMN: server can not start oracle
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-14501 : object is not partitioned
  • ora-36224 : (XSLPDSC05) workspace object is not a loop dimension
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-13151 : failed to remove exception record
  • 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.