Re: Move data to a different db?

From: R. Nightingale <nighr_at_hotmail.com>
Date: Sun, 1 Aug 1999 19:17:01 -0500
Message-ID: <7o2ock$616$1@hyperion.nitco.com>

You might want to check out the SQL*Plus COPY statement. There you need to supply the username/password_at_dbid of the from and to databases, and the select statement. There are fine examples in the SQL*Plus guide, not in the regular SQL Reference. You need to be able to connect to both databases with your session of SQL*Plus.

--rn.

Ne_Pushkin <ne_pushkin_at_my-deja.com> wrote in message news:7nvd98$gfm$1_at_nnrp1.deja.com...
> Hi!
> Could somebody please give me a hint on how to specify a different db
> using SQL*Plus INSERT INTO statement? I have two identical databases
> and I need to move data from one to another.
> Thanks for your help!
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Aug 01 1999 - 19:17:01 CDT