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 11.5.10.2 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***

Symptoms

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 :

DROP TABLESPACE APPLSYSD INCLUDING CONTENTS AND DATAFILES
CASCADE CONSTRAINTS;


Command results in following error :

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


Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References

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