Re: create table from procedure?

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.

[Quoted] 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"