Re: Can't select from ALL_TABLES in a stored procedure

> All synonyms contains, please correct me if I am wrong, 3.7 million
records?

As someone who is and has worked on many, many legacy systems, this practice is more common than you think.

And yes, 1 kilo of C4 would really help the situation.

Jeff
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1067194257.984037_at_yasure...
> Ivan Petrovski wrote:
>
> >Reason:
> >Users need to be able to link Oracle tables to MS Access. But the
database
> >is so screwed up with zillions of objects and synonyms (and we are not
> >allowed to do anything about it, for some legal reasons, contracts signed
> >with the company that sold us this crappy application, blah blah etc.).
It
> >takes ages to link just one table. But I have come up with a solution;
an
> >ODBC driver that (sorry, I, must not give any information about it)
doesn't
> >look into those SYS.ALL_SOMETHING views, but rather the indexed tables
> >created form them. It works fantastic! But I want to refresh the data in
my
> >tables daily (during night). That's why I need a procedure like this.
There
> >are actualy 11 views to gather data fom, the worst one being ALL_SYNONYMS
> >with approx. 3.700.000 records.
> >
> >
> >
> All synonyms contains, please correct me if I am wrong, 3.7 million
records?
>
> <NOT TO BE TAKEN SERIOUSLY>
> Take 1 kilo of C4 or RDX and ....
> </NOT TO BE TAKEN SERIOUSLY>
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Tue Oct 28 2003 - 05:45:20 CST