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: Deleting a column from table

Re: Deleting a column from table

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 7 Nov 1998 01:43:15 GMT
Message-ID: <01be09f0$68fd8a00$7e084a0c@default> 





Age-old question, no good answer yet.  



Two options; create a view with just the columns you want or
drop the table and re-create.  A number of ways to do this,
one way is to export the table, create an ascii file using
imp indexfile=xxx and then modify the xxx script.  Just 
be careful if any foreign keys are pointing to the table.



Maybe Oracle 9 or 10 will fix this....



Phil Cook

Received on Fri Nov 06 1998 - 19:43:15 CST












Original text of this message













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