Re: create table from procedure?

Daniel Morgan wrote:
> Volker Hetzer wrote:
> If the point of creating the table was to use it as a temp table ...
> now that you figured out how to do it ... don't.
>
> There is on need in Oracle to do this. It kills performance; kills
> scalability; and is totally unnecessary.
Actually, the point is to do a performance test... :-) So, I create about 50 tables, insert a lot, update a lot and see how the i/o system reacts.
The procedure is supposed to set up the environment. I've to use execute immediate anyway, since I use a random number generator to figure our which table to fill next with a new line.

Lots of Greetings!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"