creating temporary session table in toad

Posted on 2007-11-30
Medium Priority
Last Modified: 2013-12-12
I have been using oracle sql developer till now, but recently shifted to toad. Here when i am creating a temporary table for the session, the only available option in toad is 'TEMPORARY GLOBAL'. when i use this option, the data in my table is only there for a transaction and not for the entire session. as against this in sql developer there was a option of temporary(session) in which the table preserved rows till the whole session.
How do i make a similar table in toad where my rows are preserved for the entire session?
Question by:shruti27
LVL 11

Accepted Solution

mohammadzahid earned 750 total points
ID: 20386877
Create temporary table with PRESERVE specified in DDL. This is default method of preserving rows in Oracle.

Some software apply changes/modifications on objects where TOAD does not.
I hope this answers your question.

Author Comment

ID: 20386903
thanks mohammadzahid. the solution has worked, my table is working fine now.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question