Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr - detailed logging of sql stmts
Sybrand Bakker wrote:
> On Tue, 18 Mar 2003 14:46:44 +0100, "Christoph Seidel"
> <christoph.seidel1_at_gmx.de> wrote:
>
>> Hi there,
>>
>> is this possible? I would like to see what sqlldr tries to execute.
>> The logfile only contains an error message and so it is sometimes
>> quite difficult to find out what data does not match.
>>
>
> option 1 for 8i and higher: create an after logon trigger for the
> affected user and use the dbms_session package to put the session in
> trace (or execute immediate)
>
> option 2 for 8i and higher: use dbms_logmnr to get your statements
> from the logs.
Hm, ok, tracing... I will look for it, thanks. Received on Tue Mar 18 2003 - 15:50:19 CST