SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Temporary table best practice

Mr LonelyApr 8 2013 — edited Apr 8 2013

Hi ,

I have one temporary table and that table is being emptied ( delete from table_name) multiple times in a day through a procedure.

I just wanted to know what is the best practice to handle this scenario considering read time / space of the table / any other advantages/disadvantages?

This post has been answered by jeneesh on Apr 8 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2013

Added on Apr 8 2013

11 comments

1,714 views