Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr - detailed logging of sql stmts

Re: sqlldr - detailed logging of sql stmts

From: Christoph Seidel <christoph.seidel1_at_gmx.de>
Date: Tue, 18 Mar 2003 22:50:19 +0100
Message-ID: <b584ai$26gdhr$1@ID-143718.news.dfncis.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US