Hi Tom,

It's really a pleasure to see you back.

I recently made use of Insert /+ append +/ hint to copy some
70,0000 records from the table in one database to a table
(empty table with same structure) into another database.

I found that this command is quite fast and it took me less then
30 minutes to transfer these records which I think is good
as compared to exp/imp or any other method.

Q1) Is there any drawback of using INSERT /+append + / Hint
statement ?

Q2) Can we consider this as similar to insert statement as
far as considering factors like triggers etc

Please comment.

Best regards,
Om

or