Oracle 11gR2 on Linux
I'm debugging a procedure that moves the contents of a tablespace to another. After I moved tables, indexes, and LOBs, I still had a bunch of temporary segments (querying the dba_segments view). I attempted to drop the tablespace (including contents and datafiles), but got the 14405 error, indicating that the tablespace had partitioned indexes that referred to tables not in the tablespace. After some research, I changed the tablespace to read/write and issued an 'alter tablespace coalesce' command. Querying the dba_segments view again returned no segments in the identified tablespace. However, I'm still getting the 14405 error when I attempt to drop the tablespace. I also queried the dba_indexes and dba_ind_partitions to check if any indexes or partitions existed in the tablespace, but none were reported. I'm at a loss now, since the error insists that index partitions exist in the tablespace, but everything else tells me the tablespace is empty. Any thoughts?