| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
