Re: Oracle 8.1.7 problem creating simple materialized view

On Tue, 07 Mar 2006 07:44:37 -0800, Jack wrote:

> Remote database ak_test has user "AK123" .....
>
> I connect to my database as user "XYZ123"....
>
> the dblink on my database to remote database is ak_test
>
> create database link ak_test
> connect to AK123
> identified by password
> using con_string;

NExt step, if I were doing the investigation, would be to watch the actual console session (cut and paste) from user XYZ123 for a complete select [a single column? to kis] from remote table that is causing problems, create a MV for that exact select, run the query to invoke the MV. The key would be no editing (other than embarassing typos and passwords) and no intermediate logoffs.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***