Create Table ...as select Vs. Insert Statements
Would someone happen to know what is the difference between migrating tables from one database to another using the command "create table table_name as select * from schema.table_name@link" as opposed to creating the table and then running insert statement for all the data.
I choose to migrate the table with its data using the "create table.......as select statement because it accomplishes the same thing as doing creating a table and running an insert script with a bunch of insert statements(approx 1000 records). I believe it is also faster and generates less redo files, therefore less activity on the database.
The other dba in this office requested that I do insert statement every time I migrate tables with data from one database to another, I'm not sure if there is a benefit to this since both methods accomplish the same thing.
Please advise, thank you.