ORA-13116: [string]_FACE$ table does not exist

Cause : The AFCE$ atble ofr th etopoolgy ddi note xisti n th edataabse.

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

Ther eis as ever ecorrputiono f th etopoolgy. aCll Oarcle uSppor tServcies wtih th eerro rnumbre.

update : 27-06-2017
ORA-13116

ORA-13116 - [string]_FACE$ table does not exist
ORA-13116 - [string]_FACE$ table does not exist

  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-24143 : invalid evaluation context name
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-19256 : XQ0036 - missing type definitions in imported module
  • ora-39113 : Unable to determine database version
  • ora-01324 : cannot add file string due to DB_ID mismatch
  • ora-12596 : TNS:internal inconsistency
  • ora-31018 : Error deleting XML document
  • ora-27016 : skgfcls: sbtinfo returned error
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-28522 : error initializing heterogeneous capabilities
  • ora-12072 : updatable materialized view log data for "string"."string" cannot be created
  • ora-09911 : Incorrect user password.
  • ora-14150 : missing SUBPARTITION keyword
  • ora-16245 : paging in transaction string, string, string
  • ora-26534 : collision: tranID number ignored and purged
  • ora-01279 : db_files too large
  • ora-36224 : (XSLPDSC05) workspace object is not a loop dimension
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-24155 : rule string.string not in rule set string.string
  • ora-02780 : Name given for the core dump directory is invalid
  • ora-07244 : ssfccf: create file failed, file size limit reached.
  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-06413 : Connection not open.
  • ora-00264 : no recovery required
  • ora-29823 : object being analyzed is not a table
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-02450 : Invalid hash option - missing keyword IS
  • ora-07402 : sprst: cannot restore user signal handler.
  • 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.