Skip to Main Content
  • Questions

  • Viewing columns for Oracle private temporary tables

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Arnold.

Asked: February 18, 2021 - 11:16 pm UTC

Last updated: February 22, 2021 - 11:27 am UTC

Version: Oracle Database 19C

Viewed 1000+ times

You Asked

Once a private temporary table is created I can see it in DBA_PRIVATE_TEMP_TABLES, but how can I list its columns? I can find any information about it.

and Chris said...

The definition of private temporary tables only exists in memory and they are only accessible and visible to the session that created them.

Very limited information is available about these in the data dictionary - *_PRIVATE_TEMP_TABLES is the only method I know of.

Remember that two sessions can - at the same time - create a PTT with the same name but different columns. So it's on you to manage the this within your session.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Design

New to good database design? Check out Chris Saxon's full fundamentals class.