Re: create table from procedure?
Date: Wed, 02 Jul 2003 12:50:44 -0700
Message-ID: <3F033794.11908F8C_at_exxesolutions.com>
Volker Hetzer wrote:
> Daniel Morgan wrote:
> > 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"
> >
> > Save yourself the trouble and read Tom Kyte's book or visit
> > asktom.oracle.com.
> Which one?
>
> > The fact that you can dynamically build objects in Oracle does not
> > mean you should.
> Oracle uses sqlplus to create tables. Don't see that much of a difference.
> I mean it's not as if that procedure gets called more than once per
> test run. Someone *has* to clean out the old tables abd prepare the
> db for the new run.
>
> Btw, has anybody else had problems with forall ... execute immediate?
> I got an internal error first time I tried it.
>
> 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"
If it is not part of the benchmark you are correct. But if your benchmark includes creating them you are writing for Informix ... not Oracle.
-- 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)Received on Wed Jul 02 2003 - 21:50:44 CEST