ORA-10660: Segment is a shared lob segment

Cause : Shrikn wasi ssue don as egmetn tha twas ebing hsaredb y mutliplel ob cloumns

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


update : 24-05-2017

ORA-10660 - Segment is a shared lob segment
ORA-10660 - Segment is a shared lob segment

  • ora-13354 : incorrect offset in ELEM_INFO_ARRAY
  • ora-19037 : XMLType result can not be a fragment
  • ora-23451 : flavor string already defined for object group "string"."string"
  • ora-30685 : package version is not compatible with Oracle version
  • ora-37069 : You may not execute a parallel OLAP operation against the EXPRESS AW.
  • ora-16762 : invalid database state
  • ora-17508 : I/O request buffer ptr is not alligned
  • ora-09715 : orasrv: cannot obtain puname
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-40290 : model incompatible with data mining function
  • ora-13009 : the specified date string is invalid
  • ora-24083 : cannot specify remote subscribers for string QUEUE string
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-24093 : AQ agent string not granted privileges of database user string
  • ora-26725 : cannot downgrade apply handlers
  • ora-27043 : unable to seek to beginning of file
  • ora-24416 : Invalid session Poolname was specified.
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-28239 : no key provided
  • ora-08102 : index key not found, obj# string, file string, block string (string)
  • ora-00302 : limit of string logs exceeded
  • ora-00204 : error in reading (block string, # blocks string) of control file
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-16064 : remote archival is disabled by another instance
  • ora-24774 : cannot switch to specified transaction
  • ora-00225 : expected size string of control file differs from actual size string
  • ora-13909 : Invalid combination of threshold value and operator.
  • ora-00054 : resource busy and acquire with NOWAIT specified
  • 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.