Re: Creating 100,000+ tables.

"DaLoverhino" <DaLoveRhino_at_hotmail.com> wrote:

>The reason why I want to create all these tables, is I'm suppose to
>write some tools for the DBA admins I can't think of any specifics off
>hand, since it's whatever the DBA's ask me to do, but often times I
>have to hit tables like DBA_TABLES, and often times, the queries I
>write can be slow, since many of these DBA_ views are big, and the
>constructor queries for them are quite complex.
>
>So, what I want to do, is compare constructing a sql query that goes
>against DBA_XX vs going against the underlying sys tables. Since I
>have a database to play around with, I want to compare 10k tables, 20k,
>100k.
>
>So I want to create a script to make X tables, or X objects, or
>whatever. Then, I want to store these scripts away for a later time,
>if I need to poke around with performance again.
>
>Anyways, that's really the reason.
>
>Thanks for all your suggestions.

So basically you want to reinvent the wheel instead of using some the many,many Oracle dba-related tools out there ( Oracle's own, TOAD, etc)..

Seems a little like programmer self-abuse... Received on Thu Dec 08 2005 - 10:58:34 CST