Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to move data beween servers
Hi.
> > 4) insert /*+ APPEND */ into tab as select * from
> tab_at_dblink_old_db
>
> this doesn't work for LOB type.
Yes it works. Just selecting a lob column from remote table doesn't work,
but insert ... select works.
Read the documentation if don't believe.
Tanel. Received on Mon Mar 10 2003 - 16:48:56 CST