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

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)