Re: Failed to populate free_table_stats

In our last gripping episode xo55ox_at_hotmail.com wrote:
> Hi,
>
> I have a problem on populating the free_table_stats table. It failed
 to
> generate any data after running the freespace.sql script. Then, I
 tried
> that again by scheduling/running analyze.sql, check_free.sql and
> tspfree.sql. The result is the same. What did I do wrong? I did the
 same
> for other databases but it got no problem.
>
> Information will be appreciated. Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Verify that the view TFVIEW exists. If not you'll need to run the tfprep.sql script. You should then start seeing results.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.