GLOBAL TEMPORARY TABLE
- From: Nirmalya Das <nirmalya@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 22 Oct 2006 18:25:42 -0700
Hi Folks,
I have several tables like the following in our database.
CREATE GLOBAL TEMPORARY TABLE ENTITYCACHE
(
ENTITYNO VARCHAR2(20 BYTE)
)
ON COMMIT DELETE ROWS
NOCACHE;
The question I have is, on COMMIT the data is moved to the "online redo logs"
and then gets deleted. I don't really care about the data and could not use
"NOLOGGING" as well to negate the operation of moving the data to the "online
redo logs".
Any suggestions how to use these Temporary Tables but not burden the system of
writing it to the "online redo logs".
Thanks,
Nirmalya
--
//www.freelists.org/webpage/oracle-l
Other related posts:
