Re: Reduce the No. of Fields in a Oracle Table

From: Richard Scholz <richard_at_subito.de>
Date: 1995/07/26
Message-ID: <richard.806749856_at_moon>#1/1

>The simplest way is to create a new table based on a query of the initial table, drop the old
>table, then rename to the new one.

And what can I do, if the table contains a LONG VARCHAR ? ;-) The INSERT INTO .. SELECT .. doesn't work then.

For this I found no other solution than writing a program which copies row by row. Is it possible with sql*loader or PL/SQL ?

Richard

---

Subito Software GmbH, Frankfurt, Germany richard_at_subito.de Received on Wed Jul 26 1995 - 00:00:00 CEST