Re: Best way to move data beween servers

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

To be more precise:

insert into tab select * from tab_at_dblink

Tanel. Received on Mon Mar 10 2003 - 16:51:27 CST