Re: Creating 100,000+ tables.

DaLoverhino 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.

I think the DBAs need to be taken into a room and receive a good explanation of the skill set they are expected to have.

What you have been asked to do, at least as you understand it and have communicated it here, is about as ridiculous as anything I've seen so far this year. I'd suggest you start by getting written instructions.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)