Re: Tables using triggers/procedures

All,

I just want to create multiple tables for load/stress test of our application, which is SQL Tuner.

No matter about the data types / logic / table name.........

Here primary requirement is to fill up the database. I am using Oracle 10g r2

Thanks,
Venu S.

DA Morgan wrote:
> venus wrote:
> > I want to create multiple tables in a user, using
> > trigger/procedure/loop ....what ever is preferrable. Can any one help
> > me with the script for the same?
>
> If what you are asking is how to create multiple tables ... using
> triggers and procedures containing loops, to create those tables
> my recommendation would be that you drop the idea and instead present
> a description of the actual business problem and your Oracle version
> number.
>
> The fact that it is possible doesn't mean you should consider doing it.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Fri Dec 08 2006 - 23:29:18 CST