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

Posted by Janine Ohmer on
Unfortunately, dropping the table won't get rid of the space used by the LOBs. The only way to do this is to not restore them at all.

The example from the Ask Tom site goes like this:

  • create the new table (minus the column you don't want)
  • rename to table_TEMP
  • create a view with the same name as the table, and with all the columns in the table as it exists in the dump
  • write a trigger that will fire instead of doing an insert into the table, and use it to insert the columns you do want into table_TEMP
It's quite ingenious, but I can't get it to work!