SQL> select owner, segment_name, segment_type, tablespace_name 2 from dba_segments 3 where tablespace_name = 'DATA_P1'; no rows selected SQL> 可以看出,DATA_P1表空间中已经没有任何数据,但删除该表空间时,提示ORA-14404,从错误提示可以看出有分区表在其他的表空间中存在分区,同时这张分区表可能也使...
ERROR at line 1: ORA-14404: partitioned table contains partitions in a different tablespace 解决方法: select 'alter table '||owner||'.'||segment_name||' drop partition '||partition_name||' ;' from dba_segments where segment_name in (select distinct segment_name from dba_segments where t...
6.删除索引 drop index INDEX_NAME 7 删除表空间 drop tablespace wqdb01 including contents and datafiles; 这样就不会出现ORA-14404:分区表包含不同表空间中的分区以及 ORA-14405: 分区索引包含不同表空间中的分区 的问题
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later: ORA-14404 or ORA-14407 When Trying to Drop a Tablespace
ERRORatline 1: ORA-14404: partitionedtablecontainspartitionsina different tablespace SQL> 1 2 3 4 5 6 7 8 $ oerr ora 14404 14404, 00000,"partitioned table contains partitions in a different tablespace" // *Cause: An attempt was madetodropa tablespace whichcontainstables ...