Home -> Usenet -> comp.databases.oracle -> Re: pl/sql simple help - analyze table avail?

Re: pl/sql simple help - analyze table avail?

From: Brian Graham <GrahamB_at_psac.com>
Date: 1995/03/31
Message-ID: <3lguli$amv_at_nic.ott.hookup.net>#1/1 








>>In article <odysscci.258.000E0507_at_teleport.com>, odysscci_at_teleport.com (Jim Kennedy) writes:
 


  |> << Big snip re stored procedure usage >>


 


  |> --  won't work -> analyze table :tabName compute statistics;

  |> 

  |> 

  |> TIA,


  |> Jim Kennedy


  |> 





  If you're not running the command from the table owner, just prefix
the tablename with the schemaname. Synonyms to the table are insufficient.
Ie. anayze table scott.emp compute statistics;
  Works for us in our sql scripts.


                                        Brian


--
Brian Graham                    .
Programmer / DBA        ._______|_______. Tel: 613-560-5470
Public Service Alliance       \(*)/       Fax: 613-563-3492
of Canada                     o/ \o       Email: grahamb_at_psac.com


Received on Fri Mar 31 1995 - 00:00:00 CEST












Original text of this message