Skip to Main Content
  • Questions
  • Viewing columns for Oracle private temporary tables


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 100+ 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 we 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.

More to Explore


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