Database Administration (MOSC)

MOSC Banner

11gR2 : How to stop audit/trace files generation when importing data ?

edited Sep 22, 2013 1:38PM in Database Administration (MOSC) 2 commentsAnswered
 Hi ,

I would like to know , how to stop audit and trace generation in 11g database when trying to do un IMPORT with oracle imp utility.

/app/oracle/oradiag/diag/.../trace/*.trm
/app/oracle/oradiag/diag/.../trace/*.trc
/app/oracle/oradiag/diag/.../trace/trace/metadata/*.ams
/app/oracle/oradiag/diag/.../trace/trace/lck/*.lck

I have tried NOAUDIT ALL;
and these actions :
alter system set audit_trail=NONE scope=spfile;
alter system set trace_enabled=FALSE scope=both;
alter system set audit_sys_operations=FALSE scope=both;

but problem still remains  and SYS.AUD$ grows ... when importing data threfore import fails because no space available ...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center