ORA-01752: cannot delete from view without exactly one key-preserved table

ORA-01752: cannot delete from view without exactly one key-preserved table

Cause: The deleted table either had no key perserved tables, had more than one key-preserved table, or the key-preserved table was an unmerged view or a table from a read-only view.

Action: Redefine the view or delete it from the underlying base tables.

ORA-01751: Invalid dump undo option

ORA-01751: Invalid dump undo option

Cause: An invalid option is specified in the ALTER DUMP UNDO command.

Action: Correct and reissue the command.

ORA-01743: only pure functions can be indexed

ORA-01743: only pure functions can be indexed

Cause: The indexed function uses SYSDATE or the user environment.

Action: PL or SQL functions must be pure (RNDS, RNPS, WNDS, WNPS). SQL expressions must not use SYSDATE, USER, USERENV(), or anything else dependent on the session state. NLS-dependent functions are OK.

ORA-01742: comment not terminated properly

ORA-01742: comment not terminated properly

Cause: The indicated comment or hint begun with the or * token did not have the terminating * or .

Action: Properly terminate the comment or hint with a * or .

ORA-01734: illegal parameters - EXTENT MIN higher than EXTENT MAX

ORA-01734: illegal parameters - EXTENT MIN higher than EXTENT MAX

Cause: A wrong value is specified for the parameter.

Action: Correct the parameter and reissue the statement.

ORA-01725: USERENV( COMMITSCN ) not allowed here

ORA-01725: USERENV( COMMITSCN ) not allowed here

Cause: The function USERNEV( COMMMITSCN ) is only allowed as a top-level expression in the VALUES clause of an INSERT statements, and on the right hand side of an assignment in an UPDATE statement.

Action: Correct the use of the function.

ORA-01724: floating point precision is out of range (1 to 126)

ORA-01724: floating point precision is out of range (1 to 126)

Cause: Self-evident.

Action: Self-evident.