hi
i am transferring contents of text file into database table using sqlldr.It works fine
sqlldr uname/pwd@db control=ctr.ctl log=error.log
But when i give the table name wrong in control file it does not capture table not found in log file.
I need to make this entry in log file
help please
ancy
Last Activity: Sep 12 '06, 04:26 AM
Joined: Sep 8 '06
Location:
-
hi
I got the solution. -
Upsert operation
hi,
I am trying to do an upsert operation(inser t/update) using merge function in oracle 8.1.7,
But it doesnt work .What is the equivalent thing to merge in oracle 8.1.7 -
Update
hi all,
hi all,
I have a table which has 3 columns col1,col2,col3. THe col1,col2 gets the values from text using sqlldr.(in script)
for col3 update is done
like
update table
set col3='$value'
this value can change for every executiom
When the script is execute for first time (3 record are inserted and updated with given value).But for the second time if text file has... -
how to captue oracle errors in log file in unix script
hi all
I am calling a procedure within script.Even if the prcoedure is not executed successfully. In log file it is recorded as procedure successfully executed .How to capture errors in log file
$SQP $clf_user_name/$clf_password@$ db_server <<EOF> file_out_before .log
update table set col='a';
commit;
exec BatchImportCurs or('$criteriano ','$filename');
commit;
EOF
...
No activity results to display
Leave a comment: