AUTO REFRESH NOT WORKING [message #366471] |
Thu, 22 July 1999 11:56 |
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, China [message #366531 is a reply to message #366471] |
Mon, 04 September 2000 08:53 |
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 |
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.
|
|
|