Re: help appreciated with db-link CTAS

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 12 Jul 2002 17:43:56 +0100
Message-ID: <1026492453.27276.0.nnrp-12.9e984b29@news.demon.co.uk>

It was a note in the forum

CTAS across database link dated 20th Dec 2001

<quote>
RDBMS Version: 8.1.7
Operating System and Version: solaris 5.6

From: Oracle, Rowena Serna 23-Dec-01 01:33 Subject: Re : CTAS across database link

Donald is right. We only try mapping the cursor to remote site only if it is SQL, not DDL, not CTAS.

You can try,
create views on D1 of T1 & T2 and then create your table locally.

Regards,
Rowena Serna
Oracle Corporation
<end quote>

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  July / Sept
 Australia August
 Malaysia September
 USA (MI) November

http://www.jlcomp.demon.co.uk/seminar.html

Telemachus wrote in message ...


>Thanks Jonathan but it's an 3rd party app

>

>do you remember the metalink number ? I looked and couldn't find anything

>directly relevant

>

>67530.1 seems the closest - was that it ?

>

>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message

>news:1026142025.25153.0.nnrp-13.9e984b29_at_news.demon.co.uk...

>>

>> I am slightly surprised that you got the

>>     load as select

>>       remote

>> at all - I recall reading a note on Metalink recently

>> that said the  expected behaviour was the

Received on Fri Jul 12 2002 - 11:43:56 CDT