Error occured during creation of oracle snapshot

Il messaggio oggetto di questo post compare frequentemente e in SO01 trovate questo itime:

Error occured during deletion of snapshot (Delete process aborted)
(Log see also transaction SLG1, Object ORASNAP, Subobject ORASNAPDE)
Error while deleting snapshot (table / returncode) ORA_SNAPSHOT / 4

Per risolvere, da sqlplus, collegati come sysdba, eseguite i seguenti comandi:

create or replace view sap_$ksmsp as select * from x$ksmsp;
drop public synonym sap$ksmsp;
create public synonym sap$ksmsp for sap_$ksmsp;
grant select on sap$ksmsp to public;

create or replace view sap_$kcbfwait as select * from x$kcbfwait;
drop public synonym sap$kcbfwait;
create public synonym sap$kcbfwait for sap_$kcbfwait;
grant select on sap$kcbfwait to public;

create or replace view sap_$bh as select * from x$bh;
drop public synonym sap$bh;
create public synonym sap$bh for sap_$bh;
grant select on sap$bh to public;

A questo punto, le viste mancanti dobrevvero esistere:  SAP$KSMSP, SAP$KCBFWAIT o SAP$BH

Advertisements

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...