Re: How to remove statistics?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 10 Jun 1999 23:44:38 +0200
Message-ID: <929050997.25346.0.pluto.d4ee154e@news.demon.nl>

on schema level
execute dbms_utility.analyze_schema('<schemaname>','DELETE')

on table level
analyze table <table_name> delete statistics

Hth,

Sybrand Bakker, Oracle DBA

kal121_at_my-deja.com wrote in message <7jorja$nej$1_at_nnrp1.deja.com>...
>Just need a simple answer:
>
>What is the command to remove statistics (from analyzed tables, etc)?
>
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 10 1999 - 16:44:38 CDT