sqlloader: automatically inserting stats into table [message #70449] |
Fri, 14 June 2002 13:09 |
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 automatically into a table in Oracle.
|
|
|
Re: sqlloader: automatically inserting stats into table [message #70450 is a reply to message #70449] |
Fri, 14 June 2002 13:15 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
hello,
Im still working on your problem.
im looking for a workaround.
becuase the records are discarded, only becuase it is having some PROBLEM WITH THE DATABASE.
Then how can u expect to load them again into another table, without identifying the problem?
anyhow u can just identify count of records inserted, discarded etc using v$LOADTSTAT if you are using a direct=ture.
but its not a generic solution!. Eecause there a lot of restrictions using direct=true.
you can write a trigger on the target table so as to count the new inserted records, and populate that to another table. But how can you count the DISACARDED records?
i am also looking for a workaround.
|
|
|