Solved

creating temporary session table in toad

Posted on 2007-11-30
2
2,155 Views
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?
0
Comment
Question by:shruti27
2 Comments
 
LVL 11

Accepted Solution

by:
mohammadzahid earned 250 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.
0
 

Author Comment

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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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‚Ķ
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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 how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now