ORA-02247: no option specified for ALTER SESSION



ORA-02247: no option specified for ALTER SESSION..

Answer / guest

Cause: The option SET EVENTS was expected, but not found,
following ALTER SESSION.

Action: Place the SET EVENTS option after ALTER SESSION.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PROT-00004: Failed to retrieve data from the cluster registry

1 Answers  


NNL-00575: list_objects: list all objects in a domain or subtree

1 Answers  


NCR-03015: NCRO: No transport address

1 Answers  


IMG-00521: invalid value for dataOffset

1 Answers  


DRG-11524: primary key value is missing

1 Answers  






NNO-00626: cannot enable DEFAULT-FORWARDERS-ONLY mode, no default forwarders exist

1 Answers  


SQL*Loader-00925: Error while string

1 Answers  


ORA-24092: invalid value string specified

1 Answers  


SQL*Loader-00531: OCI return status: still executing

1 Answers  


NNL-00853: Renames refused, new name already exists: number

1 Answers  


ORA-35076: (QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.

1 Answers  


ORA-39003: unable to get count of total workers alive

1 Answers  


Categories