OraFAQ Forum: SQL & PL/SQL » sqlloader rows successfully loaded (urgent)

Home » SQL & PL/SQL » SQL & PL/SQL » sqlloader rows successfully loaded (urgent)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlloader rows successfully loaded (urgent) [message #20679]

Thu, 13 June 2002 09:08

krusher
Messages: 3
Registered: June 2002

Junior Member

Is there a way to insert the rows successfully loaded from the sqlloader process into another table in Oracle? When it is finishing the loading process, I would like to insert the number of rows loaded, discarded records and others into a table in Oracle.

Report message to a moderator

Re: sqlloader rows successfully loaded (urgent) [message #20680 is a reply to message #20679]

Thu, 13 June 2002 09:19

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

this view may help you.


SQL> DESC V$LOADTSTAT;
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ---------------
 LOADED                                                         NUMBER
 REJECTED                                                       NUMBER
 FAILWHEN                                                       NUMBER
 ALLNULL                                                        NUMBER
 LEFT2SKIP                                                      NUMBER
 PTNLOADED                                                      NUMBER

SQL*Loader statistics compiled during the execution 
of a direct load. These statistics apply to the
current table. Any SELECT against this table 
results in "no rows returned" since you cannot 
load data and do a query at the same time. 

<u>Column   Datatype  Description  </u>
LOADED   NUMBER    Number of records loaded  
REJECTED NUMBER    Number of records rejected 
FAILWHEN NUMBER    Number of records that failed 
                   to  meet any WHEN clause 
ALLNULL  NUMBER    Number of records that 
                   were  completely null and were
                   therefore not loaded 
 
LEFT2SKIP NUMBER   Number of records yet to skip 
                   during a continued load 
 
PTNLOADED NUMBER   Number of records loaded PTN

Report message to a moderator

Re: sqlloader rows successfully loaded (urgent) [message #20698 is a reply to message #20679]

Fri, 14 June 2002 07:15

krusher
Messages: 3
Registered: June 2002

Junior Member

Can you tell me how I would be able to collect this information and insert it into a table in Oracle automatically? When the sqlloader script is finishing and the total rows and rejects are tabulated, I would like to capture that information and insert it into a table.

Report message to a moderator

Previous Topic:	datediff
Next Topic:	Printing Title on the report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:20:17 CDT 2024