Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Best method for updating tables
My company is breaking into the Oracle world and we are looking for the
best way to be able to update the table structures at our customers' sites.
We were looking at writing a script that would create a new table under a
temporary name, insert the data, drop the old table and then rename the new
table. Is this the best way or is there a better way to do this. Also
would it be better to use bulk copy for tables with large amounts of data
compared to a normal insert statement?
Mark Received on Sun Oct 31 1999 - 14:27:57 CST