Re: Oracle 8i with Column Delete

Steve <schen_at_prodigy.net> wrote:
>Hi,
>
>Does anyone knows whether Oracle 8i (816+) can delete column directly
>instead of using imp/exp?

Yes. See syntax for ALTER TABLE in the SQL Reference.

ALTER TABLE emp SET UNUSED COLUMN deptno; ALTER TABLE emp DROP COLUMN deptno;

SET UNUSED just deletes the column entry from the data dictionary DROP deletes it, but needs a row-lock on *every* row in the table. Don't do this to your fact table at 10am :-)

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/