Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

audit public database link by session

susieqNov 3 2010 — edited Nov 3 2010

I've upgraded from 10g to verion 11.2 and am running my auditing scripts. At:

audit public database link by session;
audit public synonym by session;
audit rollback segement by session;

I get an "ORA-32595: DDL statement cannot be audited with BY SESSION specified". Surely, when I removed the 'by session' in each link, it worked. But why do these scripts work in 10g but no in 11g?

Thanks in advance for any insight.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2010

Added on Nov 3 2010

#11g, #database-upgrade, #in

1 comment

424 views