Hi All,

I am using two global temporary tables (can't use a join with a CONNECT BY)
and can't drop them. I keep getting

"ORA-14452: attempt to create, alter or drop an index on temporary table
already in use"

I don't have an explicit index on them, and am not using them that I know
of. Any enlightenment would be greatly appreciated.

Thanks,

Mike Milligan
Oracle LazyDBA home page