var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
My question is can we know the user which dropped or truncate table , partitions or indexes ??
How can we know it
thanks 4 the reply
With the help of AUDIT feature.
please look at here for more information...
MS Computer Science
OCP DBA 9i/8i
Exactly Auditing is the feature which keeps you updated with operation on tables. If I remember it correctly AUD$ is the table from which we can find out the necessary info..
Go through the documentation before using it.
Also a DDL trigger may help (8i+ only)
create or replace trigger ...
after drop on schema ...
Never used myself - but it may help you .
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors