| GT Table [message #471034] |
Thu, 12 August 2010 00:58  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hello,
I have some doubts on the below questions, please turn some light on these.
Question 1:
I can create a temp table with CTAS method, but if I specify the options (On commit.....) then it is not supporting. Why?
Question 2:
can we share a Temp Table to any other users? If not then,
What is the meaning of this statement:
"we can truncate the table, which will releases the binding between the session and the table, but won't affect ANY OTHER SESSIONS that use the same temp Table"
Question 3:
Is it possible to use Sql*loader utility to the temp Table?
Question 4:
in a statement "we can't create a Temp Table on IOT, CLUSTER, PARTITIONED", but in another statement I seen a command for creating temp Table on that above mentioned. Is this available in any new release?
Question 5:
If we can't create a Temp Table on the above mentioned, then tell me the reason
Why it is not possible?
Question 6:
will the objects from Temp segment creates no redo record? Or less amount of redo records? Why so, please the reason....
Question 7:
Is there any way to find out the particular table's total amount of redo generation records in online redo log?
Including temp Table?
Question 8:
What is the default option of temp Table, is it session based or transaction based?
How to identify that for a existing temp Table?
Thanks in advance.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
