[Home] [Help] [Dependency Information]
Object Name: | GV_$TEMPFILE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
FILE# | NUMBER | |||
CREATION_CHANGE# | NUMBER | |||
CREATION_TIME | DATE | |||
TS# | NUMBER | |||
RFILE# | NUMBER | |||
STATUS | VARCHAR2 | (7) | ||
ENABLED | VARCHAR2 | (10) | ||
BYTES | NUMBER | |||
BLOCKS | NUMBER | |||
CREATE_BYTES | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
NAME | VARCHAR2 | (513) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, FILE#
, CREATION_CHANGE#
, CREATION_TIME
, TS#
, RFILE#
, STATUS
, ENABLED
, BYTES
, BLOCKS
, CREATE_BYTES
, BLOCK_SIZE
, NAME
, CON_ID
FROM SYS.GV_$TEMPFILE;
|
|
|