ORA-14401 error occurred while deleting the tablespace in which the partition table is located

Database: Oracle11.2.0.3

Ora14401 error occurred when deleting the tablespace where the partition table is located:

SYS @ vimop01_ B> drop tablespaceUSER_TS_MONI_11B including contents and datafiles;

Drop tablespace USER_TS_MONI_11B including contents anddatafiles

*

ERROR at line 1:

ORA-14404: partitioned table contains partitions in adifferent tablespace

Solution:

Select segment_name, partition_name from dba_segments wheretablespace_name = 'user _ TS_MONI_11B ';

Select * from dba_tab_partitions wheretablespace_name = 'user _ TS_MONI_11B ';

Delete the objects in the tablespace. Some empty partition tables do not generate segment and cannot be seen under dba_segments. You need to find dba_tab_partitions and delete all the partitions found.

Delete operation commands such as ALTER TABLEMON_DATA_DAY_BUFFER_TOTAL drop partition D_20120530;

SYS @ vimop01_ B> drop tablespaceUSER_TS_MONI_11B including contents and datafiles;

Tablespace dropped.

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store