Re: copying LOBs

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 3 Oct 2000 15:18:35 +0100
Message-ID: <8rcprs$l02$1@soap.pipex.net>

Check out the DBMS_LOB package supplied with Oracle.I believe it is also referenced in the excellent O'Reilly book on built in packages.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Will Hartung" <will.hartung_at_havasint.com> wrote in message
news:8qvuff01pfu_at_news1.newsguy.com...


> I'm wondering what folks are doing to transfer LOBs between tables.

> Specifically between to different networked databases.

>

> In a perfect world it would be as trivial as :

>     insert into newtable select that, that, other from oldtable

>

> Of course, this doesn't work with LOBs.

>

> Any insight appreciated.

>

> Will Hartung

> (will.hartung_at_havasint.com)

>

>

>

Received on Tue Oct 03 2000 - 09:18:35 CDT