i'm not acquainted with the file structure you're using, but if every log file has the same data format, i would recommend against creating a new table for each file you process...that would be redundant... if you know the format beforehand , create a table using the Enterprise Manager in SQL 7 , and let your perl script insert data into that table for all the log files you process...