Re: Move data to a different db?

From: Paul Q <paulq_at_home.com>
Date: Sun, 01 Aug 1999 15:08:15 GMT
Message-ID: <zpZo3.22037$um6.251271@news2.rdc1.on.home.com>

insert into table
select * from table_at_db

You may have to a "create database link"

Ne_Pushkin wrote in message <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 - 10:08:15 CDT