Re: Datafiles question

From: <rspeaker_at_my-dejanews.com>
Date: Tue, 02 Mar 1999 12:42:00 GMT
Message-ID: <7bgmam$kt6$1@nnrp1.dejanews.com>

You can find information about autoextend mode and filesizes in dba_data_files. Initial / Next extents are not set on the datafiles themselves, but on the various objects within the datafiles.

HTH,
Roy

In article <19990301212611.11656.00001958_at_ng-cd1.aol.com>, john0725_at_aol.com (John0725) wrote:
> Hi.
>
> I want to be able to find the following information about my datafiles using
> SQL statements, but I can't find the info in the system views. Can anyone
> help?
>
> 1) Is the datafile in autoextend mode?
> 2) Does the datafile have a maximum size?
> 3) What is the size of the initial extent and next extent of the datafile?
>
> If anyone can help, I would appreciate it. Please email to john0725_at_aol.com.
>
> Thanks.
>
> --John
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 02 1999 - 06:42:00 CST