ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT
- 2 Answers
- 9580 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
RMAN-05010: target database must be opened in READ WRITE mode for TSPITR
DRG-10002: can not insert into result table
ORA-16038: log string sequence# string cannot be archived
UDE-00051: unable to set NLS_NUMERIC_CHARACTERS to required defaults.
ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA
ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.
ORA-24350: OCI call not allowed
ORA-06405: NETCMN: reset protocol error
PLS-00667: Element type of associative array should be pls_integer or binary_integer
NZE-28797: invalid key data type
TNS-12664: Services required by server not available on the client
TNS-00514: Contexts have different wait/test functions
Oracle Errors 
