ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT

Answers were Sorted based on User's Feedback



ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT..

Answer / guest

Cause: Attempt to specify BY ACCESS | SESSION in a NOAUDIT
statement.

Action: Remove BY ACCESS | SESSION.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT..

Answer / shafi ur rahmaan

PLEASE USE THIS COMMAND

SQL>NOAUDIT SESSION BY SESSION WHENEVER NOT SUCCESSFUL;

ORA-01718: BY ACCESS | SESSION clause not allowed for
NOAUDIT

USE THIS COMMAND

SQL>NOAUDIT SESSION WHENEVER NOT SUCCESSFUL

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32021: parameter value longer than string characters

1 Answers  


ORA-13193: failed to allocate space for geometry

1 Answers  


UDE-00053: unrecognized client command 'string'

1 Answers  


NZE-29027: Error in entropy collection

1 Answers  


DRG-11805: Accepted

1 Answers  


ORA-32011: cannot restore SPFILE to location already being used by the instance

1 Answers  


PROC-00009: Cannot perform cluster registry operation because the buffer passed is too small.

1 Answers  


RMAN-08071: channel string: deleting archive log(s)

1 Answers  


ORA-02295: found more than one enable/disable clause for constraint

1 Answers  


ORA-00722: Feature "string"

1 Answers  


ORA-09314: sltln: error translating logical name

1 Answers  


NNL-00854: Fastest rename processing time: string

1 Answers  


Categories