January 3, 2013

Bulk insert records into table in sql or oracle

This is the way to Bulk insert records into table in sql or oracle

insert into dTable select * from sTable
if dTable is blank and doesn't have any record.


Create this as follows: definately reduce the time.

CREATE TABLE dtable NOLOGGING AS SELECT * FROM stable

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.