Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hot to copy tables from one oracle user to another

Re: Hot to copy tables from one oracle user to another

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 31 May 2003 23:10:11 +0200
Message-ID: <vdi6ng7aom8c9@corp.supernews.com>

"Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message news:798Ca.13198$JP3.5754_at_fe10.atl2.webusenet.com...
> What's the benefit of sqlplus copy over say something like following?
>
> create table "destination_db_copy_name" as select * from
> "source_db_copy_name"@"db_link_name_of_source_db";
>
> Of course, where the things in "" are your names of tables and database
> link.
>
> If both methods do not copy indexes or grants or synonyms or whatever else
> export/import does catch, then I don't see a need for the sqlplus copy
> command ?
>
> Seems to me if you don't use export/import, you might as well just issue
the
> create table in the destination database and do something like "insert
into
> dest-tb select * from source-db_at_dblinkname". This way you are more in
> control and easily can see what's missing (what commands like create index
> you have not done yet).
>

Insert select won't use the array interface, and you won't be capable to commit every n rows. COPY is also the only way to copy longs from one table to another.

But rest assured, COPY will be removed from 10i

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sat May 31 2003 - 16:10:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US