Re: fastest method to copy data between databases

When I try to do a snapshot against a remote view containing multiple tables, I get "ORA-01445 cannot select ROWID from view of more than one table". Oracle told me that there was a bug in 7.1.6 that prevents remote snapshots against multiple tables, but that it was fixed in 7.2.3. I haven't heard about RPNS purity.

I'm going to try your SQL*Loader suggestion, as I've read that is the fastest way to replicate data. I don't have a good feel yet for our db/processor organization to be able to tell if parallel queries would help. Has anyone had experience with parallel queries?

Thanks again.

> What is the Oracle 7.1.6 bug?
>
> We're running 7.1.6 & are using complex snaphots against remote databases
> without any problems. Actually I tell a lie, one snapshot did have a problem
> as it was using user defined functions without RPNS purity (I posted about
> this a coupel of days ago). Having got rid of the offending code so the
> functions _can_ use RPNS purity, they work fine. Maybe that is the cause of
> your problem?
>
> As Oracle provide support for snapshots, you may as well use it.
>
> If not, why not run a query on your remote machine into a flat file; copy or
> remotely mount the file, then just Sql*Load it into your warehouse using
> direct path loading?
>
> Cheers.
> Martin.

David Pelinka - Programmer/Analyst	Direct/Voice: (503)-977-4379
Portland Community College, SY CC 224	Fax: (503)-977-4987
PO Box 19000 Portland, OR. 97280-0990	Internet: dpelinka_at_pcc.edu
--------------------------------------------------------------------