Cleaning Up L$ Global Temporary Tables
I have thousands of L$nnn tables in the SYS schema as the result of bitmap join index creation. When can they safely be dropped and what's the appropriate method for dropping them? I was thinking of a scheduled task to drop L$nnn tables older than a given date. Is that safe?
Thanks...judie
0