Re: CREATE TABLE AS

You can also use COPY command (it's documented in Oracle Server Docs.)

+--------------------------------------------------------------------------+
| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

soukch_at_my-dejanews.com wrote:

> 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 Thu Apr 08 1999 - 15:17:16 CDT