Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Best method for updating tables

Best method for updating tables

From: Mark Makkas <makkas_at_mediaone.net>
Date: Sun, 31 Oct 1999 15:27:57 -0500
Message-ID: <PC1T3.4608$IT5.293821@ndnws01.ne.mediaone.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US