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

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

  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-07713 : sksamtd: could not mount archival device (SYS$MOUNT failure)
  • ora-01243 : system tablespace file suffered media failure
  • ora-14623 : Value string does not exist in subpartition string
  • ora-19101 : CONTENT keyword expected
  • ora-09301 : osncon: local kernel only supported in standard mode
  • ora-08186 : invalid timestamp specified
  • ora-19736 : can not plug a tablespace into a database using a different national character set
  • ora-26093 : input data column size (number) exceeds the maximum input size (number)
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-08260 : ora_addr: cannot open nameserver
  • ora-31030 : Unable to retrieve XML document
  • ora-16174 : user requested thread/sequence termination of managed recovery
  • ora-31671 : Worker process string had an unhandled exception.
  • ora-19561 : %s requires a DISK channel
  • ora-01549 : tablespace not empty, use INCLUDING CONTENTS option
  • ora-13704 : Invalid value "string" specified for parameter "string".
  • ora-36674 : (XSDPART12) Invalid dimension value starting at string.
  • ora-28141 : error in creating audit index file
  • ora-02751 : osnfsmmap: cannot map shared memory file
  • ora-00087 : command cannot be executed on remote instance
  • ora-36185 : (XSAGGR11) workspace object does not have any AGGCOUNT information.
  • ora-38419 : invalid identifier in attribute : string
  • ora-39071 : Value for string is badly formed.
  • ora-19036 : Invalid query result set in newContextFromHierarchy()
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-08310 : sllfop: Bad value for recsize
  • ora-38708 : not enough space for first flashback database log file
  • ora-24379 : invalid user callback type
  • ora-02357 : no valid dump files
  • 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.