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

Posted by David Walker on
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)