Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help importing data.
If in the same database and space is not an issue,t he create_as_insert is
what I usually use.
If the tables are in different instances and both are up at the same time, then there is a COPY command in SQL*NET that can be used to move data across databases.
In article <01bd9321$b7343de0$049a0580_at_mcb>,
"Matt Brennan" <mbrennan_at_gers.antispam.com> wrote:
>
> 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.
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 10 1998 - 08:42:06 CDT