ORA-29927: error in executing the ODCIStatsCollect / ODCIStatsDelete routine

Cause : Th eODICSttasCloletc /O DCSItastDeeltef untcio nisc auisnga n rero.r

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

Chcek hte DOCItSatCsolelct/ OCDISattseDleet fnuctoin.

update : 26-09-2017

ORA-29927 - error in executing the ODCIStatsCollect / ODCIStatsDelete routine
ORA-29927 - error in executing the ODCIStatsCollect / ODCIStatsDelete routine

  • ora-30460 : 'string.string' cannot be refreshed because it is marked UNUSABLE
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-02041 : client database did not begin a transaction
  • ora-00067 : invalid value string for parameter string; must be at least string
  • ora-38904 : DML error logging is not supported for LOB column "string"
  • ora-35024 : (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
  • ora-28653 : tables must both be index-organized
  • ora-31484 : source database version must be at least or greater
  • ora-31121 : The string operator can not be FALSE
  • ora-14507 : partition corrupt. all rows do not fall within partition bounds
  • ora-08331 : Wait operation timed out
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-32501 : Writing SGA to file failed
  • ora-01583 : unable to get block size of control file to be backed up
  • ora-15115 : missing or invalid ASM disk size specifier
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-22286 : insufficient privileges on file or directory to perform string operation
  • ora-27046 : file size is not a multiple of logical block size
  • ora-14512 : cannot perform operation on a clustered object
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-12445 : cannot change HIDDEN property of column
  • ora-30953 : XML minoccurs value (string) violated
  • ora-09310 : sclgt: error freeing latch
  • ora-32836 : database user string must be granted role string
  • ora-01164 : MAXLOGFILES may not exceed string
  • ora-30433 : 'string.string' is not a summary
  • ora-07483 : snlkget: cannot convert(get) lock.
  • ora-30184 : argument type not compatible with a format code
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-01696 : control file is not a clone control file
  • 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.