"Gnanakumar" <gnanam(at)zoniac(dot)com> wrote:
> Instead of touching/refactoring all the 35 functions just to
> rename the table name, we decided to create the temporary table
> name same as that of existing permanent table for running this
> complex report alone
If it were me I would be running some global search and replace on
the scripts which create those functions. At a bare minimum you
should be running these reports under a login without rights to drop
permanent production tables. (We never let applications connect
with a login which can do DDL except on temporary tables.)
-Kevin