ORA-10657: Lob column to be shrunk does not exist

Cause : Shirnkw asi sseud no al obs egemntt ha tdi dno texsit

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


update : 22-07-2017

ORA-10657 - Lob column to be shrunk does not exist
ORA-10657 - Lob column to be shrunk does not exist

  • ora-24369 : required callbacks not registered for one or more bind handles
  • ora-03134 : Connections to this server version are no longer supported.
  • ora-24903 : invalid namespace attribute passed into OCI call
  • ora-12804 : parallel query server appears to have died
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-30204 : buffer is not large enougth
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-19610 : directory block string is corrupt
  • ora-36887 : (XSSRF06) Error rewriting OLAP DML expression. Column name string is not a valid ADT column.
  • ora-23484 : internal internet Application Server error: string
  • ora-01534 : rollback segment 'string' doesn't exist
  • ora-32628 : invalid nesting of MODEL cell reference
  • ora-33922 : (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.
  • ora-01425 : escape character must be character string of length 1
  • ora-25116 : invalid block number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-13275 : spatial index creation failure on unsupported type
  • ora-29370 : pending area is already active
  • ora-02181 : invalid option to ROLLBACK WORK
  • ora-29929 : missing SCAN Keyword
  • ora-24302 : host connection in use by another thread
  • ora-12196 : TNS:received an error from TNS
  • ora-27123 : unable to attach to shared memory segment
  • ora-14185 : incorrect physical attribute specified for this index partition
  • ora-12583 : TNS:no reader
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-38488 : attribute set already assigned to the column storing expressions
  • ora-37142 : (XSSQLMDQ02) Invalid host variable data type for MDQUERY procedure: string expected.
  • ora-13839 : V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
  • ora-23322 : Privilege error accessing pipe
  • 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.