I'm just wondering if the best way to handle a rollback of added columns is
to alter the table to mark the column as unused and then drop the unused
columns via ALTER TABLE t1 DROP UNUSED COLUMNS; or would the ideal thing be
to export the table(s) before adding the columns and then reimport, alth
Rich, i'm with you.
dropping a column can be extremely time consuming depending on number of
rows.
just go ahead and add the cols to prod, if you need to back it out, mark
them unused and then drop them during a slow time(i know you're 24x7 but
look when its the slowest, 3AM?).
joe
Richard Hunt