Database Administration (MOSC)

MOSC Banner

Cleaning Up L$ Global Temporary Tables

edited Jun 16, 2009 6:06AM in Database Administration (MOSC) 3 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center