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 : 25-04-2017

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

  • ora-08000 : maximum number of session sequence lists exceeded
  • ora-15067 : command or option incompatible with diskgroup redundancy
  • ora-25116 : invalid block number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-15017 : diskgroup "string" cannot be mounted
  • ora-19909 : datafile string belongs to an orphan incarnation
  • ora-22869 : depth of type dependency hierarchy exceeds maximum limit
  • ora-01541 : system tablespace cannot be brought offline; shut down if necessary
  • ora-16509 : the request timed out
  • ora-24322 : unable to delete an initialized mutex
  • ora-12497 : maximum combined categories exceeds string
  • ora-39062 : error creating master process string
  • ora-25158 : Cannot specify RELY for foreign key if the associated primary key is NORELY
  • ora-12216 : TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA
  • ora-30383 : specified dimension level does not exist in the attribute
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-27487 : invalid object privilege for a string
  • ora-02305 : only EXECUTE, DEBUG, and UNDER privileges are valid for types
  • ora-12342 : open mounts exceeds limit set on the OPEN_MOUNTS parameter
  • ora-36812 : (XSTBLFUNC06) Invalid Syntax at '?'.
  • ora-19639 : file string is more current than this incremental backup
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-06533 : Subscript beyond count
  • ora-01649 : operation not allowed with a backup control file
  • ora-00722 : Feature "string"
  • ora-12171 : TNS:could not resolve connect identifier: string
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-06537 : OUT bind variable bound to an IN position
  • ora-26525 : session connection attempt failed for string (@string)
  • ora-29701 : unable to connect to Cluster Manager
  • 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.