Re: Is Autoextend ON??

From: <holmesb_at_my-dejanews.com>
Date: Mon, 14 Dec 1998 21:06:37 GMT
Message-ID: <753ukr$k9e$1@nnrp1.dejanews.com>

In article <01be2788$7968cf20$5646ea9e_at_ukp02062.logica.co.uk>, "Igor " <espiaui_at_hotmail.com> wrote:
>
> Is there a way of checking if the option AUTOEXTEND
> is ON for a particular tablespace??
>
> Thanks
> Igor
>

Check for the presence of the FILEXT$ table owned by SYS. If it doesn;t exist, then autoextend has not been turned on for any TS/data file.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 14 1998 - 15:06:37 CST