You could also just spool the data to a file concatenating each column with
a delimiter character and then load the file into the new table and/or
database with SQL*Loader. When spooling, turn feedback, verify, heading,
and echo to 'off' and set pagesize to 0. You don't have to use a delimited
file either - fixed length is available, but delimited is usually easier to
set up in SQL*Loader's control file, especially if you have a table with a
lot of columns. See the Oracle Server Utilities manual for SQL*Loader
instructions.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
Robert Prendin <rprendin_at_magi.com> wrote in article
<35203067.2183136043_at_news.istar.ca>...
> There is no SQL syntax, export and import are Oracle utilities that
> must be run on their own...Read the docs...
>
> If the tables already exists and you import with IGNORE=Y, import will
>
> import just the data....
>
> Don Mark <dmark_at_telis.org> wrote:
>
> >What is the SQL syntax to 1) export and 2) import just the **data** of a
> >table?
> >
> >Thanks, Don
>
>
Received on Wed Apr 01 1998 - 00:00:00 CST
