DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Threaded View

  1. #1
    Join Date
    Jun 2003

    Question 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.
    Last edited by LoriWong; 06-19-2003 at 11:16 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

By using this site, you agree to the Privacy Policy