| How to avoid redo log entries for a table [message #211940] |
Wed, 03 January 2007 02:59  |
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
|
Member |
|
|
Dear All,
I'm working in oracle 9i under unix o/s,I want to avoid redo log entries for a table, i've putted that table into nologging mode, but when normal DML statement fired through my application, it's entry is going into redo log.
I cannot use Insert ... As Select .., because data is inserted into that table through an application, that data is of temporary use and it is deleted after transaction.
I've tried NOLOGGING clause and APPEND hint for that, but it is not working as it will work only with direct load insert.
Is thr any method to avoid that redo log entries, or is thr any way to convert normal DML into direct load insert, by using some hint or something like that.
If i create an index-organized table, then is it possible to avoid redo log entries.
Thanx in Advance
Amit
|
|
|
|
|
|
|
|
|
|
| Re: How to avoid redo log entries for a table [message #212377 is a reply to message #211998] |
Fri, 05 January 2007 01:01  |
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
|
Member |
|
|
Hi,
Is this possible that instead of firing insert statement on that table, i call a procedure and write the ouput in a text file, and create a external table to fetch the data from thr. After completion of transaction I remove that flat file or overwrite it when new transaction starts.
Please guide me that i'm on a right step or not?
Thanks
Amit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
