Srinivas Sastry wrote:
My Application reads data from a flat file every day and inserts into a table whose name is like * <<CONSTANT>> appended by <<YYYY_MM_DD>>*So the table name changes everyday (the table will end with date on which the data is inserted).
Maybe you could try to insert everything into <<CONSTANT>>_TEMP, and thend use native SQL to rename the table?
Regards, Ognjen
