Re: Select count(*) from dba_free_space > 250000

Hi,

You are right, this soution is a bad one ...

But, in my case, I had a database in 8.1.6 with all tbs managed in the dictionnary.

This solution was taken for a customer because the situation was urgent. Of course, now he use LMT in an 9i db.

Any ideas are welcome

Regards

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<k2m2juk3vrkrn1lgdgtevckd3qfpgoo6t0_at_4ax.com>...
> On 14 Jul 2002 02:15:47 -0700, ydias_at_hotmail.com (dias) wrote:
>
> >Hi,
> >
> >I had the same problem.
> >The solution, for me, was to recreate the view DBA_FREE_SPACE without
> >accessing LMT, since I didn't use this feature.
> >
> >Regards
>
> Yeah, it is really a brilliant solution to screw the datadictionary.
> Oracle is probably going to drop the phone on you as soon as you get
> into *real* trouble.
> Also, please keep in mind, in 9i DMTs are only retained for backwards
> compatibility. They are on the way out.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Jul 14 2002 - 13:36:11 CDT