全部博文
-
编辑 删除
删除分区表所在表空间遇到ORA-14401错误
数据库：Oracle11.2.0.3 删除分区表所在表空间遇到ora14401错误： 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 解决方法： select segment_name,partition_name from dba_segments wheretablespace_name='USER_TS_MONI_11B'; select * from dba_tab_partitions wheretablespa
