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-10632: Invalid rowid

1 Answers  


ORA-07751: slemcr: malloc failure

1 Answers  


ORA-07492: scgrcl: cannot close lock.

1 Answers  


PLS-00585: declared support library for opaque type is not a library

1 Answers  


LSX-00261: invalid character property

1 Answers  






ORA-31221: DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.

1 Answers  


NNL-00930: Requests refused, unknown data type: number

1 Answers  


ORA-30456: 'string.string' cannot be refreshed because of insufficient privilege

1 Answers  


ORA-01287: file string is from a different database incarnation

1 Answers  


ORA-01489: result of string concatenation is too long

1 Answers  


ORA-02772: Invalid maximum server idle time

1 Answers  


ORA-01202: wrong incarnation of this file - wrong creation time

1 Answers  


Categories