IP Database

[chriskeeler]

I have an Oracle Database, and created a cloaking script to match IP address of spiders. Is there an easy way of getting all the IP's and UA's into the database without manualy entering them in?

How often do IP's change or new one pop up?

Thanks for your help.
Sincerely,
Christopher Keeler

[Air]

Welcome to WmW Christopher.

With Oracle you should have a utility that will read a file and load the data. From what I recall many file formats are acceptable, except CSV which seems to confuse sqlloader. Sorry but I don't remember more than that about Oracle, was a while ago....

[Brett_Tabke]

If you are running Perl and DBI, there are a few new "one size fits all" Sql management scripts. A couple have options of importing csv files right into sql tables.