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

Sybrand Bakker wrote:

> "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

Likely aloong with LONGs though I can't be sure of that.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)