Re: Datafiles question

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 03 Mar 1999 16:23:33 +0100
Message-ID: <36DD53F5.5E2CF801@psi.de>

A comfortable way to get this information is using a tool like Hora 3. See http://www.keeptool.com for a free trial version of Hora 3.

regards Jan Dieckmann

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
Received on Wed Mar 03 1999 - 09:23:33 CST