Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze

Re: Analyze

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: Thu, 8 Oct 1998 19:56:08 +0800
Message-ID: <6vkn88$9us$2@news.seed.net.tw> 






>Josef Huber wrote:


> Hello,


>


> Is there a command with that i can analyze a entire schema ?







You can use DBMS_UTILITY.ANALYZE_SCHEMA(schema, method, ....),



Ex:


    EXEC DBMS_UTILITY.ANALYZE_SCHEMA('SCOTT', 'COMPUTE');



Received on Thu Oct 08 1998 - 06:56:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US