My Oracle Support Banner

Unable to drop tablespace APPLSYSD when migrating to OATM (Doc ID 369526.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle E-Business Suite Technology Stack - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 20-May-2013***


After migration to the new tablespace model OATM on a 11.5.7 Release on HP Tru64 the drop of the tablespace APPLSYSD errors out :

Command results in following error :

ERROR at line 1:
ORA-22868: table with LOBs contains segments in different tablespaces


The Database was migrated to the new OATM DB model, which is prefered since the availability of Release 11.5.9.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.