Skip to Main Content
Forums

SQL & PL/SQL

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!

Bulk INSERT and UPDATE using NOLOGGING

943310Jun 25 2012 — edited Jun 25 2012
Hi,
I need to do a bulk insert of around 10million records. Would the below insert options with NOLOGGING mode work ?

1. INSERT INTO EMPLOYEEDUMMY NOLOGGING (SELECT * FROM EMPLOYEES)
2. INSERT INTO TEMP_TABLE NOLOGGING VALUES('Cyrus','Daniel')

Also can the nologging mode be used in UPDATES like -

UPDATE TEMP_TABLE NOLOGGING SET DESC1 = 'Ethan' WHERE DESC1 = 'Cyrus'.

Will the above queries give the desired results or will the NOLOGGING keyword here be considered as table alias ?

Thanks in Advance.

Regards,
Nikhil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2012
Added on Jun 25 2012
4 comments
23,062 views