Re: drop column
From: Simone Hausmann <hausmann_at_originet.com.br>
Date: Mon, 24 May 1999 15:36:08 -0300
Message-ID: <374ab7bd.0_at_news.americasnet.com>
Date: Mon, 24 May 1999 15:36:08 -0300
Message-ID: <374ab7bd.0_at_news.americasnet.com>
Hi
You can only drop columns at Oracle 8i
wozi <wozi_at_dhc.net> wrote in message
news:89B1685359915855.0F022C9888CA6793.35F7ACE70F7959B6_at_library-proxy.airnew
s.net...
>The DROP option is for dropping constraints.
>
>1. You could create a new_table AS Select col1, col2, col3 from old_table
>2. You could also spool the table (specifying columns) to a text file,
>then use SQL*LOADER to bring it back into oracle
>
>Someone else may have other ideas.
>
>hope that helps.
>
>Michael Ginzburg wrote in message <7i93p7$l3h$1_at_news.netvision.net.il>...
>>Hi!
>>
>>How to drop column in Oracle? I haven't found such operation in ALTER
>TABLE?
>>
>>
>
>
Received on Mon May 24 1999 - 20:36:08 CEST