When does an Oracle Global temp table go out of scope?

If I create a global temporary table in Oracle, will it be deleted if the server is rebooted? Or shut down and restarted? Besides me explicitly deleting the global temporary table, I am looking for ways in which it might be deleted or go out of scope.
LVL 2
brgdotnetcontractorAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
The table will ALWAYS be there.  The data in it is what is removed when the session ends or when a commit happens depending on if it preserves rows or not.  Only the session that inserts data into it can see the data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.