Re: Dropping columns in Oracle 7.3.4

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Tue, 11 Jan 2000 06:41:08 GMT
Message-ID: <8EB8981Cdlm@206.141.192.241>

claire.moore_at_capgemini.co.uk (Claire Moore) wrote in <387A174B.574_at_capgemini.co.uk>:

>A while back I saw a message from someone advising of a utility they
>knew that could allow you to drop columns from a table without

don't know of a utility program as such.

you could export your tables and specify "rows=no" so that all the constraints are exported without the rows; then do the create table as select, eliminating the bad columns; rename the tables so the good table has the original table name; then reload the export file with "ignore=yes". imp should complain about the pre-existance of the table, but should load the constraints.
--
dave mausner Received on Tue Jan 11 2000 - 00:41:08 CST