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

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).

-- 

"Carsten Saager" <carsten_at_saager.org> wrote in message
news:bbasu2$7b909$1_at_ID-74580.news.dfncis.de...


> "Hans Forbrich" <forbrich_at_telusplanet.net> schrieb im Newsbeitrag

> news:3ED8E2C1.FCBAB92E_at_telusplanet.net...

> > "Yuri Weinstein (HotMail)" wrote:

> >

> > > and users are on different orcale servers?

> >

> > Many variants - one being exp/imp (export / import)

> >

> or the COPY command of sqlplus ... needs less privileges

>


> Carsten

>
>