• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2541
  • Last Modified:

creating temporary session table in toad

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
shruti27
Asked:
shruti27
1 Solution
 
mohammadzahidCommented:
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
 
shruti27Author Commented:
thanks mohammadzahid. the solution has worked, my table is working fine now.
0
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

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now