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

From: Alastair Newson <anewson_at_cix.compulink.co.uk>
Date: 1995/07/27
Message-ID: <DCECsx.K0q_at_cix.compulink.co.uk>#1/1

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

Check out the SQL*Plus COPY command (NB SQL*Plus not a SQL command), you can use this to copy tables including longs. The copy is based on a SQL statement to define the copy set.

regards

Alastair Received on Thu Jul 27 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Mats Larsson: "Re: Reduce the No. of Fields in a Oracle Table"
Previous message: Jim Gregory: "Re: SQLNet v1.2 <SERVICES file lookup failure>"
In reply to: Richard Scholz: "Re: Reduce the No. of Fields in a Oracle Table"
In reply to Richard Scholz: "Re: Reduce the No. of Fields in a Oracle Table"
Next in thread: Russell McDonald: "Re: Reduce the No. of Fields in a Oracle Table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message