RE: How to preserve global temporary table data

SSC Guru

Points: 323506

March 29, 2013 at 2:01 pm

rajarshi_ghosh_05 (3/29/2013)
The highest time to keep the table alive is 120min.
Is it possible to keep the table alive by locking it or anything else?

again, no, it is not possible to guarantee that a global temp table will stay in place.

instead,create a permanent table, and add a job to delete/drop the table after 120 minutes, or have the application check a date that exists inside the now-permanent table, so the data is not used if it is over 120 minutes old.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!