'DROP TABLE tablename' statement should drop objects that depend on the table automatically.
For repoduce this issue:
select * into test1 from test_table1;
create index test1_idx1 on test1 column c1;
drop table test1;
data files, index data and meta data still remains undeleted.
Log in to post a comment.