ORA-10658: Lob column to be shrunk is marked unused

Cause : Srhikn awsi suse do nal o bsgemnett hta si amrekda su nsued

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

nnoe

update : 24-04-2017
ORA-10658

ORA-10658 - Lob column to be shrunk is marked unused
ORA-10658 - Lob column to be shrunk is marked unused

  • ora-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-12027 : duplicate filter column
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-12642 : No session key
  • ora-12615 : TNS:preempt error
  • ora-13519 : Database id (string) exists in the workload repository
  • ora-12150 : TNS:unable to send data
  • ora-02432 : cannot enable primary key - primary key not defined for table
  • ora-00071 : process number must be between 1 and string
  • ora-15132 : block string of file string in diskgroup string could not be written
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-02037 : uninitialized speed bind storage
  • ora-22323 : error table "string"."string" does not exist
  • ora-10637 : The segment does not exist
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-10660 : Segment is a shared lob segment
  • ora-02826 : Illegal block size
  • ora-19831 : incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-32134 : Cannot assign LOBs
  • ora-14265 : data type or length of a table subpartitioning column may not be changed
  • ora-30334 : illegal dimension level name
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-12638 : Credential retrieval failed
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-36685 : (XSDPART23) Only CONCAT partition templates can be subpartitioned.
  • ora-30112 : multiple values not allowed for parameter 'string'
  • ora-17502 : ksfdcre:string Failed to create file string
  • 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.