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

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

  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-14007 : missing LESS keyword
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-30964 : The XML Index was not usable.
  • ora-13249 : %s
  • ora-15012 : ASM file 'string' does not exist
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-24331 : user buffer too small
  • ora-36690 : (NTEXTCNV01) Error during conversion from NTEXT to TEXT.
  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-15071 : ASM disk "string" is already being dropped
  • ora-15026 : disk 'string' is not an ASM disk
  • ora-22894 : cannot add constraint on existing unscoped REF columns of non-empty tables
  • ora-03212 : Temporary Segment cannot be created in locally-managed tablespace
  • ora-28273 : No mapping for user nickname to LDAP distinguished name exists.
  • ora-39501 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-28110 : policy function or package string.string has error
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-28655 : Alter table add overflow syntax error
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-12679 : Native services disabled by other process but required
  • ora-04008 : START WITH cannot be more than MAXVALUE
  • ora-00269 : specified log file is part of thread string not string
  • ora-01271 : Unable to create new file name for file string
  • ora-13443 : GeoRaster metadata SRS error
  • ora-27165 : tried to join thread that does not exist
  • ora-06918 : CMX: T_NOEVENT during wait for read event
  • ora-29854 : keyword BITMAP may not be used in creating domain indexes
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • 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.