How do find that your global temporary table is defined with "on commit preserve rows" or "on commit delete rows"?

Questions by RenukaRajput   answers by RenukaRajput

Showing Answers 1 - 1 of 1 Answers

meenakvasulochanan

  • Aug 17th, 2007
 

The column "duration" in all_tables will tell us whether the temporary table is defined with "on commit preserve row" or "on commit delete rows"
The values :

SYS$TRANSACTION    -  On Commit delete rows
SYS$SESSION            -  On Commit preserve rows.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions