Unable to drop tablespace APPLSYSD when migrating to OATM
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;
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