Re: Analyze

From: Reinhard <reinhard_wahl_at_gmx.de>
Date: 1999/11/16
Message-ID: <38318444.25295603_at_zv>#1/1


On Tue, 16 Nov 1999 15:19:17 -0000, "Screamer" <mflopes_at_bigfoot.com> wrote:

>How can i analyze all tables/indexes that belong to a user ?

SQL> exec dbms_utility.analyze_schema('<schema>', 'COMPUTE')

hope this helps
  Reinhard



Replace '_' with '.' in e-mail adress to send a pm
Received on Tue Nov 16 1999 - 00:00:00 CET

Original text of this message