How about creating a script like this..
Code:
SELECT DISTINCT
'ALTER TABLE '||TABLE_NAME||' ADD (new_col_name new_data_type);'
FROM USER_TAB_COLUMNS
MINUS
SELECT DISTINCT
'ALTER TABLE '||TABLE_NAME||' ADD (new_col_name new_data_type);'
FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'new_col_name'
Sanjay

[Edited by SANJAY_G on 10-17-2002 at 10:16 PM]