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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

insert and delete

just a DBAFeb 26 2013 — edited Feb 27 2013

I would like to clarify the situation.

1. create table t1 as select * from t2.
2. delete from t1.

Why second statement is several times slower than insert if it just moves the same amount of data into undo segments ?

This post has been answered by Jonathan Lewis on Feb 27 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2013

Added on Feb 26 2013

#general-database-discussions

10 comments

661 views