ORA-00000 till ORA-00057

ORA-00000:
normal, successful completion
Cause:
Normal exit.
Action:
None.
----------------------------------------------------------------------------------------------
ORA-00001:
unique constraint (string.string) violated
Cause:
An UPDATE or INSERT statement attempted to insert a duplicate key. For trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.
Action:
Either remove the unique restriction or do not insert the key.
----------------------------------------------------------------------------------------------
ORA-00017:
session requested to set trace event
Cause:
The current session was requested to set a trace event by another session.
Action:
This is used internally; no action is required.
----------------------------------------------------------------------------------------------
ORA-00018:
maximum number of sessions exceeded
Cause:
All session state objects are in use.
Action:
Increase the value of the SESSIONS initialization parameter.
----------------------------------------------------------------------------------------------
ORA-00057:
maximum number of temporary table locks exceeded
Cause:
The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
Action:
Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.

0 Responses to "ORA-00000 till ORA-00057"