Forum OpenACS Q&A: Response to Oracle - loading a table minus one column

Collapse
2: Response to Oracle - loading a table minus one column (response to 1)
Posted by David Walker on 09/16/02 09:06 PM
How about restoring, "select (non-LOB columns) into tmptable", "drop
tablename", "alter table tmptable rename to tablename"?  (Or
something similar, my syntax might be off or might be wrong for
Oracle, I have experience with Postgres and MS SQL)