What's the best performance-wise way to change the size of a column that contains data ? (in a table with a really large number of rows)
with an appended column in the same table, a temp table, some system magic, etc ?
I add a column using execute immediate 'alter table .. add ..'; and then try to set some values to it in the same pl/sql block. I'm getting an ORA-00904 - invalid identifier. The column name is 'DBTMPCLMN', which I believe is valid. What is the issue here, do I need to somewhat commit the execute immediate changes after them ?
Here is an example - http://pastebin.com/ZNeSRLpX , I'm getting an invalid identifier for DIFFDBTMPCLMN on line 9