volatile table question

Database
Enthusiast

volatile table question

Is there a way to connect to a volatile table in one session from a different separate session? 

alan

2 REPLIES
Senior Supporter

Re: volatile table question

no, they are session local.

Check the documentation.

Volatile Tables

Volatile tables do not have a persistent definition; they must be newly created each time you

need to use them. The table definition is cached only for the duration of the session in which it

is created.

Enthusiast

Re: volatile table question

Okay, thanks, Ulrich.  I was thinking that maybe if the session id was known then it may be possible.  Appears that was wishful thinking  . . .

alan