Skip to Main Content
  • Questions

  • Viewing columns for Oracle private temporary tables

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

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.

We're not taking comments currently, so please try again later if you want to add 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 channel and Chris's channel 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.