ORA-29933: object being disassociated has some user defined statistics stored

Cause : There rae someu ser deifned sttaisticsc ollectde for teh objec tbeing idsassocaited.

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

First edlete teh user edfined tsatistisc and tehn reisuse the IDSASSOCAITE comamnd or psecify hte FORC Eoptionw ith DIASSSOCIAET.

update : 28-04-2017
ORA-29933

ORA-29933 - object being disassociated has some user defined statistics stored
ORA-29933 - object being disassociated has some user defined statistics stored

  • ora-24362 : improper use of the character count flag
  • ora-00153 : internal error in XA library
  • ora-37150 : line string, column string, string
  • ora-30453 : summary contains AVG without corresponding COUNT
  • ora-29345 : cannot plug a tablespace into a database using an incompatible character set
  • ora-02196 : PERMANENT/TEMPORARY option already specified
  • ora-24091 : Destination queue string is the same as the source queue
  • ora-06111 : NETTCP: disconnect failure
  • ora-06323 : IPA: Cause event error
  • ora-06770 : TLI Driver: error sending version
  • ora-19608 : %s is not a backup piece
  • ora-12463 : undefined group string for policy string
  • ora-27024 : skgfqsbi: sbtinit2 returned error
  • ora-33456 : (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
  • ora-12224 : TNS:no listener
  • ora-00280 : change string for thread string is in sequence #string
  • ora-13903 : Invalid combination of string threshold value and operator.
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-19552 : device type string is invalid
  • ora-23345 : table "string"."string" not registered to collect statistics
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-10361 : check buffer change vector count consistency
  • ora-27202 : skgfpen: sbtpcend returned error
  • ora-15193 : Internal ASM tracing event number 15193
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-07391 : sftopn: fopen error, unable to open text file.
  • ora-24086 : cannot create a 8.0 compatible string queue
  • ora-09935 : Unlink of current password file failed.
  • ora-19002 : Missing XMLSchema URL
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • 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.