Re: insert into local table user select from remote db

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 17 Feb 2005 16:56:44 GMT
Message-ID: <4214cca0.1281786982@localhost>

what is it you're trying to accomplish here, and why speed is important? For one time table creation, 20mins might be sufficient, for data replication look into snapshots.

On 16 Feb 2005 11:41:40 -0800, zibinyang_at_gmail.com wrote:

>I tried "create table as" yesterday, it's same as insert. the table is
>new created.
>for sure there is not trigger there.
>I will trace it and see what happend.
>Anyway thanks for the help. I will use export/import. it only take few
>minutes.
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Feb 17 2005 - 10:56:44 CST