ORA-23345: table "string"."string" not registered to collect statistics

Cause : A procedure that deals with conflict resolution statistics-gathering was called for a table that was not registered to collect statistics.

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

Call dbms_repcat.register_statistics to register the table.

update : 28-05-2017
ORA-23345

ORA-23345 - table "string"."string" not registered to collect statistics
ORA-23345 - table "string"."string" not registered to collect statistics

  • ora-24086 : cannot create a 8.0 compatible string queue
  • ora-13500 : SYSAUX DATAFILE clause specified more than once
  • ora-13240 : specified dimensionality greater than that of the query mbr
  • ora-26029 : index string.string partition string initially in unusable state
  • ora-29330 : Source script length too big
  • ora-16720 : no LOG_ARCHIVE_DEST_n initialization parameters available
  • ora-29379 : resource plan string is involved in a loop in top-plan string
  • ora-38951 : Target platform string not cross platform compliant
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • ora-13418 : null or invalid parameter(s) for set functions
  • ora-00040 : active time limit exceeded - call aborted
  • ora-00201 : control file version string incompatible with ORACLE version string
  • ora-02052 : remote transaction failure at string
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-31198 : Mismatch in number of bytes transferred due to non-binary mode
  • ora-19162 : XP0004 - XQuery type mismatch: invalid argument types 'string', 'string' for function 'string'
  • ora-02434 : cannot enable unique(string) - unique key not defined for table
  • ora-13432 : GeoRaster metadata blankCellValue error
  • ora-24813 : cannot send or receive an unsupported LOB
  • ora-01569 : data file too small for system dictionary tables
  • ora-33336 : (DSSEXIST04A) Analytic workspace string is not attached.
  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-01633 : Real Application Clusters Option needed for this operation
  • ora-36914 : (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and it's ancestor.
  • ora-26053 : Row was not loaded due to conversion error.
  • ora-13611 : The command string is not a valid advisor command.
  • ora-01194 : file string needs more recovery to be consistent
  • ora-12804 : parallel query server appears to have died
  • ora-37158 : Bad clob or varray IN-args: (case 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.