Re: expdp - audit

From: Oscar Ofiana <oj.ofiana_at_gmail.com>
Date: Tue, 7 May 2013 16:38:49 +1000
Message-ID: <CAPjcp6C4i0+OEY_v_A9rxtp5EkoesKvwBOK_q2sbDMU1VTMSJQ_at_mail.gmail.com>

You can also check DBA_DATAPUMP_JOBS, similar to: SQL> select owner_name, operation, job_mode, state from dba_datapump_jobs;

Hth,
OJ

On Tue, May 7, 2013 at 4:36 PM, Kamran Agayev (ICT/SNO) < itakamran_at_azercell.com> wrote:

> You can check DBA_DATAPUMP_SESSIONS view as follows:
>
> SELECT sid, serial#
> FROM v$session s, dba_datapump_sessions d
> WHERE s.saddr = d.saddr;
>
> You can also debug the running data pump job.
> http://kamranagayev.com/2013/03/11/debugging-data-pump-session/
>
>
> Sincerely,
> Kamran Aghayev A.
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of AMIT VERMA
> Sent: Tuesday, May 07, 2013 11:32 AM
> To: oracle-l
> Subject: expdp - audit
>
> hi all,
> any idea how to figure out know who runs expdp command from dba_ views.
> please help i am trouble somebody its blunder & we don't know that guy?
>
> --
> Amit Verma
> v.amit84_at_skype.com
>
>
> "Winning takes talent but it takes character to keep winning"
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 07 2013 - 08:38:49 CEST