Re: Unused Synonyms
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: rgoulet@xxxxxxxxxx
- Date: Mon, 23 Oct 2006 09:34:38 -0700
On 10/19/06, Richard J. Goulet <rgoulet@xxxxxxxxxx> wrote:
stmt := 'select count(*) from '||a.synonym_name;
You might consider amending the above SQL to 'select count(*) from
'||a.synonym_name||' where rownum < 2';
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
- References:
- RE: Unused Synonyms
- From: Richard J. Goulet
Other related posts:
- » Unused Synonyms
- » Re: Unused Synonyms
- » RE: Unused Synonyms
- » RE: Unused Synonyms
- » RE: Unused Synonyms
- » Re: Unused Synonyms
stmt := 'select count(*) from '||a.synonym_name;
You might consider amending the above SQL to 'select count(*) from '||a.synonym_name||' where rownum < 2'; -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
- RE: Unused Synonyms
- From: Richard J. Goulet