| NOLOGGING, APPEND, PARALLEL [message #65224] |
Mon, 21 June 2004 03:35  |
Ajendra Naraya Samal
Messages: 26
Registered: December 2003
|
Junior Member |
|
|
Hi
Could I please know how to combine NOLOGGING and APPEND Hint clause on INSERT INTO AS SELECT FROM.
One of my friend suggested that its always advisable to use the NOLOGGING clause if u are doing INSERT INTO AS SELECT. Could I please know in which circumstance we will avoid/use the NOLOGGING clause.
Is there any relation between NOLOGGING and APPEND clause.
Also can I be clarified on what is a parallel DML. I am cofused with the content of this link http://www.samoratech.com/tips/swnologgingmode.htm.
Thanks & Regards
Ajendra
|
|
|
|
| Re: NOLOGGING, APPEND, PARALLEL [message #65247 is a reply to message #65224] |
Sun, 04 July 2004 22:50  |
Satheesh Babu.S
Messages: 35
Registered: July 2004
|
Member |
|
|
alter session enable parallel dml;
insert /*+ append parallel(tt, 10) nologging */
into target_table tt
select /*+ parallel(st, 10) */ *
from source_table st;
Append and Nologging is entirely different. Append is taking fresh block for insertition with out worrying about the existing block in freelist. Where as Nologging is generating no log to save save time.
Thanks and Regards,
Satheesh Babu.S
Bangalore.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
