Home » Server Options » Replication » AUTO REFRESH NOT WORKING
AUTO REFRESH NOT WORKING [message #366471] Thu, 22 July 1999 11:56 Go to next message
arun k c
Messages: 2
Registered: July 1999
Junior Member
I HAVE 2 DATABASES ON THE SAME M/C AND I AM TRYING TO CREATE A SNAPSHOT.
THE FIRST TIME THE SNAPSHOT CREATES AND THE AUTO REFRESH IS NOT WORKING IT IS GIVING ME THIS ERROR
ORA-12012: error on auto execute of job 1
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_IREFRESH", line 450
ORA-06512: at "SYS.DBMS_REFRESH", line 182
ORA-06512: at line 1
IS THERE ANY PERMISSIONS TO BE GIVEN TO THE USER WHO CREATES THE DATABASE OR ANY OTHER LINES TO BE ADDED IN THE PARAMETER FILE SO THAT THE AUTO REFRESH OCCURS
EVEN THE DBMS_REFRESH GIVES ERROR.
PLEASE HELP
THANKS IN ADVANCE
arun k c
Re: AUTO REFRESH NOT WORKING [message #366487 is a reply to message #366471] Mon, 04 October 1999 16:17 Go to previous messageGo to next message
russ
Messages: 11
Registered: October 1999
Junior Member
Sounds to me like you do not have your DB links working properly.

Check the links for the schema owner of the snapshots.

Russ....
Re: AUTO REFRESH NOT WORKING [message #366529 is a reply to message #366471] Wed, 23 August 2000 14:30 Go to previous messageGo to next message
Bhupinder Singh
Messages: 1
Registered: August 2000
Junior Member
You should set QUERY_REWRITE_ENABLED = TRUE. You can set this parameter through ALTER SESSION and through INIT.ORA.
Re: AUTO REFRESH NOT WORKING, China [message #366531 is a reply to message #366471] Mon, 04 September 2000 08:53 Go to previous messageGo to next message
pand_us
Messages: 2
Registered: September 2000
Junior Member
I also met this problem!

You may try this two method:

Method A:
First, alter refresh style with COMPLETE or FORCE.
Second, execute DMBS_JOB.RUN(the snapshot's job number).

The snapshot's job number may find in USER_REFRESH.

Method B: If you installed ORACLE 8.0 or higher.
Recreate snapshot using PRIMARY KEY type snapshot.
It is
" CREATE SNAPSHOT *****
REFRRESH WITH PRIMARY KEY
AS SELECT ....."
OR
" CREATE SNAPSHOT *****
AS SELECT ....."
Re: AUTO REFRESH NOT WORKING, China [message #366532 is a reply to message #366471] Mon, 04 September 2000 09:24 Go to previous message
pand_us
Messages: 2
Registered: September 2000
Junior Member
I also met this problem. I think two method.

Method A: (I solved this problem)
First, alter snapshot refresh style with COMPLETE or FORCE;
Second, manually execute DBMS_JOB.RUN(the snapshot's job number);

note: the snapshot's job number may find in USER_REFRESH data dictionary.

Method B:(I didn't solve this problem)
Recreate snapshot using PRIMARY KEY type,it is
CREATE SNAPSHOT ****
AS SELECT .....
or
CREATE SNAPSHOT ****
REFRESH WITH PRIMARY KEY
AS SELECT .....

But I can't create snapshot with PRIMARY KEY type.
ORACLE telled 'The table don't primary key constraint'. Actually the table has primary key constraint. I don't know the cause.
Previous Topic: AQ/JMS Perl Client?
Next Topic: oracle Parallel Server
Goto Forum:
  


Current Time: Wed May 18 01:13:24 CDT 2022