DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.FILEXT$

Object Details
Object Name: FILEXT$
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about extensible files

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE# NUMBER

ID of the database file
MAXEXTEND NUMBER

Maximum size of the file in ORACLE blocks
INC NUMBER

Default increment for autoextension
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FILE#
,      MAXEXTEND
,      INC
FROM SYS.FILEXT$;

Dependencies

[top of page]

SYS.FILEXT$ references the following:

SchemaSYS
ViewDBA_DATA_FILES

SYS.FILEXT$ is not referenced by any database object