Re: Analyze

From: Reinhard <reinhard_wahl_at_gmx.de>
Date: Tue, 16 Nov 1999 16:22:27 GMT
Message-ID: <38318444.25295603@zv>

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 - 10:22:27 CST