table clone/copy

[EMW]

Is it possible to copy an Oracle database table with a SELECT command or
something else?

I tried reading the data from one table in a dataset, then renaming the
table to the one in the database and then do an UPDATE on it, but it didn't
work.

rg,
Eric

 

[William Ryan eMVP]

If the rowstate of a given row isn't modified/deleted/inserted then it's not
going to update. You could manually walk through the table and add them,
but that would be ugly. The easy way is to set the AcceptChangesDuringFill
property of the adapter to false. By default, it's set to true. When you
fill the new table, if this is set to false, all of the filled rows will be
marked as inserted, so when you call DataAdapter.Update, everything should
work provided your update logic is legit.

HTH,

Bill

 

[EMW]

thanks!

If the rowstate of a given row isn't modified/deleted/inserted then it's not
going to update. You could manually walk through the table and add them,
but that would be ugly. The easy way is to set the AcceptChangesDuringFill
property of the adapter to false. By default, it's set to true. When you
fill the new table, if this is set to false, all of the filled rows will be
marked as inserted, so when you call DataAdapter.Update, everything should
work provided your update logic is legit.

HTH,

Bill