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 : 17-08-2017
ORA-13116

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

  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-32627 : illegal pattern in MODEL FOR LIKE loop
  • ora-12712 : new character set must be a superset of old character set
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-16782 : instance not open for read and write access
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-00330 : archived log ends at change string, need change string
  • ora-23353 : deferred RPC queue has entries for object group "string"."string"
  • ora-13052 : unsupported geometric type for geometry string.string
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-16730 : error executing dbms_logstdby.skip_txn procedure
  • ora-23609 : unable to find directory object for directory string
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-01543 : tablespace 'string' already exists
  • ora-08121 : Number of indexes need to be maintained offline exceeds limit for DML
  • ora-30505 : system triggers should not reference a column in a WHEN clause
  • ora-24376 : cannot register/get user callback for non-environment handle
  • ora-19259 : XQ0039 - duplicate parameter name string in function declaration
  • ora-22333 : cannot reset type "string"."string" due to invalid dependent types and tables
  • ora-31030 : Unable to retrieve XML document
  • ora-07680 : sou2os: another call to Oracle currently executing
  • ora-06042 : NETDNT: message receive failure
  • ora-31499 : null value specified for required parameter string
  • ora-06775 : TLI Driver: error reading break mode
  • ora-22059 : buffer size [string] is too small - [string] is needed
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-29511 : could not resolve Java class
  • ora-19226 : XP0006 - XQuery dynamic type mismatch: expected string got 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.