CREATE TABLE AS

From: <soukch_at_my-dejanews.com>
Date: Thu, 08 Apr 1999 02:59:15 GMT
Message-ID: <7eh61v$ast$1@nnrp1.dejanews.com>

I want to copy Oracle table from one database to another database, Oracle suggested using CREATE TABLE AS and INSERT but there's no example. I know how to use it when the from and to are in the same database:

create table newtable
as select * from oldtable

How would I specify the from and to when it deal with 2 database.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 21:59:15 CDT