OraFAQ Forum: Unix » Badrecord Check in korn shell script

Home » Infrastructure » Unix » Badrecord Check in korn shell script

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

Badrecord Check in korn shell script [message #246763]

Thu, 21 June 2007 16:03

oraanu
Messages: 22
Registered: September 2005
Location: Boston

Junior Member

Hi,

I have to load data from Flatfile into our Database.
First I creating the temp External table from the flat file and then loading the data to the final table.I have written a shell to load the Data.After creating the temp External table I have to check the bad records in my shell script.If there is a bad record I have to Drop the temp External table and notify to the users.can anybody help me how to check whether that table has bad records or not in a shell script.

Please help me.

Thanks,
Anu

Report message to a moderator

Previous Topic:	scripts for monitoring UNIX space
Next Topic:	delete old files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 08:15:04 CST 2024