Re: create table from procedure?

Volker Hetzer wrote:

> 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"

[Quoted] Save yourself the trouble and read Tom Kyte's book or visit asktom.oracle.com.

[Quoted] [Quoted] The fact that you can dynamically build objects in Oracle does not mean you should.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)