Home > database >  Why the sysdba users unable to set the transaction to serialization
Why the sysdba users unable to set the transaction to serialization

Time:09-29

Oracle USES sysdba users perform
SET the TRANSACTION ISOLATION LEVEL SERIALIZABLE.
Will there be an error
ORA - 08178: the INTERNAL for the user to specify the SERIALIZABLE clause illegal
But ordinary users can perform, could you tell me why?

CodePudding user response:

Cause: the Serializable mode is not supported for the user INTERNAL.
Action: Reconnect as another user and retry the SET TRANSACTION command.
This is the oracle within the limit, can't say why, may be afraid to make accident on INTERNAL oracle,

CodePudding user response:

When the "regulations" to explain it,
  • Related