Again very large table

[Leonid]

Hi, please advice me with my big table. Application is CDR file treatment, data are inserted into one table and accumulated there during last month. After the expire of month some treatment made and old data should be erased. Table have some indexes for calculation purpose. Problem is the last operation (delete) have very long time for execution. I divide delete command onto much more short time period nevertheless operation still very slow.
I have an idea to distribute data on different tables with appropriate name having time hint (like t_200704 for April, 2007 data). After month treatment particular table simply dropped and database space released. But problem for me: how to create table with variable substitution? It is possible by external scripting (e.g. shell or perl script) but preferable way will be native SQL approach. Is it possible? Prepared statement look very complicated solution and not convenient...
May be my way is wrong? and there are exists another better approaches..