Re: sqlldr - detailed logging of sql stmts

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 18 Mar 2003 18:20:23 +0100
Message-ID: <s7le7v47i0bjql6ns5j0nusbp9n3fkda12@4ax.com>

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.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 18 2003 - 11:20:23 CST