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;
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 |