Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LOGGING/NOLOGGING Clause

423371Nov 3 2005 — edited Nov 3 2005
I am running an insert statement, my insert statement selects 8 million rows from table B and inserts into table A

insert into tableA (...)
select ... from tableB

I have altered both the tables to have NOLOGGING option.

Do you think this is the right way to do or I should turn NOLOGGING on tableA and LOGGING on tableB

Since it involves the insert and select of 8 millions I am converned about the performance and time it takes for the Insert to complete

Any suggestions and inputs would help

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2005
Added on Nov 3 2005
4 comments
436 views