ORA-00000 till ORA-00057
Posted by nakdararindu
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.
Ape YeH??
Posted by nakdararindu
Hari2 bila buat keje kat opis, xspecially ble debug program dah tentu jumpe error yang kekadang sama,,,tapi dah lupe error tuh tuk ape,,so kene google lah,,,untuk memudahkan keje,,aku nak buat satu koleksi error yang leh himpun sume jenis error..tak kire ORA or FRM,,,sebab dah letey ah nak cr hari2,,hehe so baek ku susah2 skrg,,hopefully dapat membantu diri sendiri and others,,,yeahhh...muLa2 kiter Listkan link2 berguna disini..
http://www.ora-error.com/
http://ora-code.com/
Subscribe to:
Posts (Atom)
