ORA-00942 in apply process [message #75764] |
Fri, 21 January 2005 04:54 |
Koen
Messages: 3 Registered: December 2002
|
Junior Member |
|
|
Hi all,
I've configured a streams test evironment using 2 9.2.0.6 database, according to the oramag article (http://www.oracle.com/technology/oramag/oracle/04-nov/o64streams.html).
From various diagnostic queries I've run, I think both capture and propagation processes are running ok. Interesting stuff shows up when querying DBA_APPLY_ERROR:
SELECT LOCAL_TRANSACTION_ID,ERROR_MESSAGE FROM DBA_APPLY_ERROR;
LOCAL_TRANSACTION_ID
----------------------
ERROR_MESSAGE
--------------------------------------------------------------------------------
10.47.86
ORA-00942: table or view does not exist
I have no clue which table it is that the error applies to. The destination table exists and the streams user has enough privileges on it.
Running DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS also gives me an ORA-00942:
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 65
ORA-06512: at "SYS.DBMS_APPLY_ERROR", line 208
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 439
ORA-06512: at line 1
I have no clue about where to go to find out which table it is that causes the error, hope someone over here can give me a hint.
TIA,
Koen
|
|
|
Re: ORA-00942 in apply process [message #75765 is a reply to message #75764] |
Mon, 24 January 2005 03:38 |
Koen
Messages: 3 Registered: December 2002
|
Junior Member |
|
|
Hi,
the problem is solved, found it by creating a logon trigger that enables sql_trace for my strmadmin user.
I was indeed the replicated table that was unaccessible by strmadmin. As I found out the hard way, role privileges are not valid inside stored procedures ..
Koen
|
|
|