Re: how to turn feedback ON when using sqlldr direct mode?
Date: Wed, 10 Mar 1999 22:23:09 GMT
Message-ID: <36e6f0c8.5617693_at_news.arnes.si>
On Tue, 09 Mar 1999 01:31:47 GMT, ewong74_at_netscape.net wrote:
>Hi there,
>
>I noticed that if I use direct mode in sqlldr, the feedback does not appear
>during loading. I would like to get the feedback like I get from non-direct
>mode:
>Commit point reached - logical record count 100
>Commit point reached - logical record count 200
>...
>
>How can I turn it on when using direct mode?
I don't think you can, because in direct path mode loader is not performing any SQL inserts+commits. It "arranges" input data into database blocks format and writes this blocks directly to db files, bypassing the SQL engine.
No SQL inserts, hence no SQL commits, hence no commit points to be reached, hence no feedback (I guess) .....
>Thanks in advance.
>
>Ed
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Mar 10 1999 - 23:23:09 CET