Re: create tablespace and the autoextend option

From: <awang5097_at_my-dejanews.com>
Date: Tue, 27 Oct 1998 18:19:25 GMT
Message-ID: <7152rc$46c$1@nnrp1.dejanews.com>

In article <36359189.3409051_at_usenet.psinet.com>, info_at_skyiimax.com wrote:
> hiya guys,
>
> Can anayone tell me which system table tells me if a tablespace has
> been created with the autoextend option (or not).
>
> Thanks in advance
>
>

If you are using Oracle 8, do a select file_name, ablespace_name,autoextensible from dba_data_files; This will give you information about the tablespace to which the datafiles belong and the setting of the autoextend option.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 12:19:25 CST