ORA-10655: Segment can be shrunk

Cause : Erro rmessgae reutrnedw hen aclledi n prboe moed by EOM

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


update : 28-04-2017

ORA-10655 - Segment can be shrunk
ORA-10655 - Segment can be shrunk

  • ora-30368 : ATTRIBUTE cannot determine column in a different relation
  • ora-16107 : all log data from primary has been processed
  • ora-26062 : Can not continue from previous errors.
  • ora-31080 : type not specified for attribute or element "string"
  • ora-24852 : protocol error during statement execution
  • ora-19870 : error reading backup piece string
  • ora-13401 : duplicate entry for string in USER_SDO_GEOR_SYSDATA view
  • ora-24190 : length of payload exceeds string
  • ora-24383 : Overflow segment of an IOT cannot be described
  • ora-01283 : Options specified is invalid
  • ora-38786 : Flash recovery area is not enabled.
  • ora-07481 : snlmatt: cannot attach to lock manager instance.
  • ora-02223 : invalid OPTIMAL storage option value
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-26031 : index maintenance error, the load cannot continue
  • ora-26524 : nls subsystem initialization failure for product=string, facility=string
  • ora-40287 : invalid data for model - cosine distance out of bounds
  • ora-12151 : TNS:received bad packet type from network layer
  • ora-12100 : materialized view log on "string"."string" already has sequence
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-03207 : subpartitioned type must be specified for composite object
  • ora-02751 : osnfsmmap: cannot map shared memory file
  • ora-01904 : DATAFILE keyword expected
  • ora-16753 : resource guard could not open standby database
  • ora-06252 : NETNTT: cannot open address file
  • ora-39014 : One or more workers have prematurely exited.
  • ora-02255 : obsolete 7.1.5
  • ora-04052 : error occurred when looking up remote object stringstringstringstringstring
  • ora-31443 : deadlock detected while acquiring lock on string
  • ora-31414 : error(s) occurred during change table advance
  • 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.