Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop column

Re: drop column

From: wozi <wozi_at_dhc.net>
Date: Sun, 23 May 1999 16:24:26 -0700
Message-ID: <89B1685359915855.0F022C9888CA6793.35F7ACE70F7959B6@library-proxy.airnews.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 Sun May 23 1999 - 18:24:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US