Re: CREATE TABLE AS

But watch out for trailing spaces on columns. There is a document from Oracle6 days that warns about trailing spaces being dropped from columns when the COPY command is used.

Andrew

Vitaliy Mogilevskiy wrote:

> 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 - 23:03:55 CDT