visualizzare errore ORA -
Gli errori ORA- possono essere visualizzati da lina di comando usando l'utlity "oerr"
La sintassi è la seguente
$ oerr ora <number>Vediamo un esempio
[oracle@oratest log]$ oerr ora 00230
00230, 00000, "operation disallowed: snapshot controlfile enqueue unavailable"
// *Cause: The attempted operation cannot be executed at this time because
// another process currently holds the snapshot controlfile enqueue.
// *Action: Retry the operation after the concurrent operation that is holding
// the snapshot controlfile enqueue terminates.
[oracle@oratest log]$ oerr ora 00230
00230, 00000, "operation disallowed: snapshot controlfile enqueue unavailable"
// *Cause: The attempted operation cannot be executed at this time because
// another process currently holds the snapshot controlfile enqueue.
// *Action: Retry the operation after the concurrent operation that is holding
// the snapshot controlfile enqueue terminates.