Quick method of making all fields NULL in a table
Howdy all,
I am using Oracle 10g R2 on windows. This is not so much as something i cannot do, but am wondering if anyone knows a quicker way to do what i am doing.
I've been tasked with changing the column specification of 30+ fields across a 9 tables. The tables massive containing over a million rows on some. The columns 'usage' is to be changed so i have null first before altering the column. The null is taking an absolute age.
Does anyone know of a way to make all fields in a column NULL other than the method i am using below.
UPDATE [TABLE] SET [COLUMN] = NULL;
Any advice would be much appreciated so i can get on with the job rather than waiting for this to complete.
thanks,
G