Please could you help me with an Oracle 9i materialized view issue.
I have materialized views setup on a laptop and a refresh group.
The database link is setup and working (tested via SQLPLUS select sysdate from dual@dblink)
However, the refresh hangs when run. I can see the session on the oracle server and it's displaying an error when running the statement for the first MV: -
ORA-02019: connection description for remote database not found.
Sorry if I haven't posted enough information - I am new to materialized view's!
We have another laptop which is setup the same way (as far as I can see) which refreshes fine!
Any assistance gratefully appreciated.