ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT
- 2 Answers
- 9850 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 |
ORA-02375: conversion error loading table string.string partition string
ORA-01304: subordinate process error. Check alert and trace logs
RMAN-10024: error setting up for rpc polling
TNS-00086: * reload - ask the Navigator to reload TNSNET.ORA
RMAN-06035: wrong version of recover.bsq, expecting string, found string
ORA-19580: %s conversation not active
RMAN-06736: Do you really want to unregister the database (enter YES or NO)?
ORA-07346: slnrm: normalized file name is too long
ORA-01102: cannot mount database in EXCLUSIVE mode
ORA-25222: enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
ORA-10659: Segment being shrunk is not a lob
TNS-00116: Pump failed during initial bequeath
Oracle Errors 
