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

Last updated on MAY 03, 2016

Applies to:

Oracle Applications 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms