Create Table ...as select Vs. Insert Statements
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Create Table ...as select Vs. Insert Statements

Threaded View

  1. #1
    Join Date
    Jun 2003
    Location
    Illinois
    Posts
    2

    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