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 : 25-04-2017

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

  • ora-13708 : Some snapshots in the range [string, string] were purged before the analysis was complete.
  • ora-00213 : cannot reuse control file; old file size string, string required
  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-08236 : smsget: cannot share subcube with listener
  • ora-28119 : policy group does not exist
  • ora-12980 : checkpoint option not allowed with SET UNUSED
  • ora-31094 : incompatible SQL type "string" for attribute or element "string"
  • ora-26744 : STREAMS capture process "string" does not support "string"."string" because of the following reason: string
  • ora-23514 : invalid or incorrect number of arguments
  • ora-00720 : ALTER DATABASE RESET COMPATIBILITY command has been de-supported
  • ora-00964 : table name not in FROM list
  • ora-12710 : CREATE CONTROLFILE character set is not known
  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • ora-01164 : MAXLOGFILES may not exceed string
  • ora-10631 : SHRINK clause should not be specified for this object
  • ora-32001 : write to SPFILE requested but no SPFILE specified at startup
  • ora-04080 : trigger 'string' does not exist
  • ora-10570 : Test recovery complete
  • ora-29293 : A stream error occurred during compression or uncompression.
  • ora-07759 : slemtr: invalid destination
  • ora-32403 : cannot use new values from mv log on "string"."string"
  • ora-22304 : input type is not an object type
  • ora-15059 : invalid device type for ASM disk
  • ora-16551 : short string copied
  • ora-00285 : TIME not given as a string constant
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-31689 : illegal value for base worker id, string
  • ora-01374 : _log_parallelism_max greater than 1 not supported in this release
  • ora-26062 : Can not continue from previous errors.
  • ora-10589 : Test recovery had to corrupt string data blocks in order to proceed
  • 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.