Re: Datafiles question

Have you tried DBA_DATA_FILES???

SQL> desc dba_data_files

 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE_NAME                                VARCHAR2(513)
 FILE_ID                         NOT NULL NUMBER
 TABLESPACE_NAME                 NOT NULL VARCHAR2(30)
 BYTES                                    NUMBER
 BLOCKS                          NOT NULL NUMBER
 STATUS                                   VARCHAR2(9)
 RELATIVE_FNO                             NUMBER
 AUTOEXTENSIBLE                           VARCHAR2(3)
 MAXBYTES                                 NUMBER
 MAXBLOCKS                                NUMBER
 INCREMENT_BY                             NUMBER

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?

Try the AUTOEXTENSIBLE column.

>2) Does the datafile have a maximum size?

MAXBYTES
>3) What is the size of the initial extent and next extent of the datafile?

This is not a property of a datafile; try DBA_TABLESPACES.

SQL> desc dba_tablespaces

 Name                            Null?    Type
 ------------------------------- -------- ----
 TABLESPACE_NAME                 NOT NULL VARCHAR2(30)
 INITIAL_EXTENT                           NUMBER
 NEXT_EXTENT                              NUMBER
 MIN_EXTENTS                     NOT NULL NUMBER
 MAX_EXTENTS                     NOT NULL NUMBER
 PCT_INCREASE                    NOT NULL NUMBER
 MIN_EXTLEN                               NUMBER
 STATUS                                   VARCHAR2(9)
 CONTENTS                                 VARCHAR2(9)
 LOGGING                                  VARCHAR2(9)

INITIAL_EXTENT and NEXT_EXTENT have the appropriate default storage properties for the tablespace.

JR

>
>If anyone can help, I would appreciate it. Please email to john0725_at_aol.com.
>
>Thanks.
>
>--John
Received on Tue Mar 02 1999 - 06:32:22 CST