Re: Need help importing data.

Unless import can do something like that (don't know enough about it to say one way or the other), spool your data to a file with SQL*Plus (and turn off formatting like column headings, pagesize, etc.) and also use a delimiter character. Then, load the data into a new table with SQL*Loader.  Or, if you're on the same database, can't you just do an insert/select?:

insert into new_table(<columns>)
select <columns>
from old_table
/
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Nick Harvey <nick.harvey_at_futurenet.co.uk> wrote in article <356E7659.6B678981_at_futurenet.co.uk>...
> Exporting and importing data. Is there any way to export just the data
> from an oracle table, and re-import it into a table with a different
> structure?
>
> Any help would be appreciated.
Received on Mon Jun 08 1998 - 16:09:31 CDT