ORA-22868: table with LOBs contains segments in different tablespaces

Cause : An attempt was made to drop a tablespace which contains the segment(s) for the LOB columns of a table but does not contain the table segment.

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

Find table(s) with LOB columns which have non-table segments in this tablespace. Drop these tables and reissue drop tablespace.

update : 16-08-2017
ORA-22868

ORA-22868 - table with LOBs contains segments in different tablespaces
ORA-22868 - table with LOBs contains segments in different tablespaces

  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-00280 : change string for thread string is in sequence #string
  • ora-16052 : DB_UNIQUE_NAME attribute is required
  • ora-13137 : failed to generate tablespace sequence number
  • ora-01560 : LIKE pattern contains partial or illegal character
  • ora-22152 : destination variable-length array is not initialized
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-06754 : TLI Driver: unable to get local host address
  • ora-13425 : function not implemented
  • ora-33288 : (DBERR15) Another user has incompatible access to analytic workspace string, and the wait timeout has expired.
  • ora-27505 : IPC error destroying a port
  • ora-12813 : value for PARALLEL or DEGREE must be greater than 0
  • ora-31096 : validation failed for schema
  • ora-24366 : migratable user handle is set in service handle
  • ora-32053 : operation not supported
  • ora-16524 : unsupported operation
  • ora-30119 : unable to obtain a valid value for 'string'
  • ora-23514 : invalid or incorrect number of arguments
  • ora-39055 : The string feature is not supported in version string.
  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-37153 : unknown exception caught: (case string)
  • ora-27457 : argument string of job "string.string" has no value
  • ora-25291 : Buffer does not exist for the specified queue
  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-30754 : column or table string stores objects of only one type
  • ora-21700 : object does not exist or is marked for delete
  • ora-19008 : Invalid version of the XMLType
  • ora-09805 : conversion of category number to string failed.
  • ora-09922 : Can't spawn process - background log directory not created properly
  • ora-16782 : instance not open for read and write access
  • 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.