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-09-2017
ORA-38479

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

  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-09908 : slkmnm: gethostname returned error code.
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-16582 : could not edit instance specific property
  • ora-02473 : Error while evaluating the cluster's hash expression.
  • ora-23401 : materialized view "string"."string" does not exist
  • ora-14319 : DEFAULT cannot be specified with other values
  • ora-28364 : invalid wallet operation
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-36639 : (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
  • ora-01336 : specified dictionary file cannot be opened
  • ora-38747 : corrupt before image (file# string, block# string)
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-36873 : (XSTFDSC03) Column type must be specified explicitly.
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-13141 : invalid RANGE window definition
  • ora-10701 : Dump direct loader index keys
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-38424 : no attribute set currently assigned to the expression set
  • ora-26678 : Streams capture process must be created first
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-16022 : LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
  • ora-32605 : invalid REBUILD option
  • ora-12519 : TNS:no appropriate service handler found
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-23292 : The constraint does not exist
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-07548 : sftopn: Maximum number of files already open
  • ora-24774 : cannot switch to specified transaction
  • 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.