2 AVAILABLE
1 AVAILABLE
5 AVAILABLE
6 AVAILABLE
7 AVAILABLE
8 AVAILABLE
9 AVAILABLE
10 AVAILABLE
11 AVAILABLE
FILE_ID STATUS
---------- ---------
12 AVAILABLE
13 AVAILABLE
14 AVAILABLE
15 AVAILABLE
16 AVAILABLE
17 AVAILABLE
18 AVAILABLE
19 AVAILABLE
20 AVAILABLE
21 AVAILABLE
22 AVAILABLE
FILE_ID STATUS
---------- ---------
23 AVAILABLE
24 AVAILABLE
25 AVAILABLE
26 AVAILABLE
27 AVAILABLE
28 AVAILABLE
29 AVAILABLE
30 AVAILABLE
31 AVAILABLE
32 AVAILABLE
33 AVAILABLE
FILE_ID STATUS
---------- ---------
34 AVAILABLE
35 AVAILABLE
36 AVAILABLE
37 AVAILABLE
38 AVAILABLE
39 AVAILABLE
40 AVAILABLE
41 AVAILABLE
41 rows selected.
SQL>
SQL> select * from dba_temp_files;
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
/oradata/test02/test02/temp01.dbf
1 TEMP AVAILABLE
SQL> select status from dba_temp_files;
---------
AVAILABLE
SQL> desc V$DATAFILE;
Name Null Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
UNRECOVERABLE_CHANGE# NUMBER
UNRECOVERABLE_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(513)
PLUGGED_IN NUMBER
BLOCK1_OFFSET NUMBER
AUX_NAME VARCHAR2(513)
FIRST_NONLOGGED_SCN NUMBER
FIRST_NONLOGGED_TIME DATE
FOREIGN_DBID NUMBER
FOREIGN_CREATION_CHANGE# NUMBER
FOREIGN_CREATION_TIME DATE
PLUGGED_READONLY VARCHAR2(3)
PLUGIN_CHANGE# NUMBER
PLUGIN_RESETLOGS_CHANGE# NUMBER
PLUGIN_RESETLOGS_TIME DATE
SQL> select file#,status from V$DATAFILE;
FILE# STATUS
---------- -------
1 SYSTEM
2 ONLINE
3 ONLINE
4 ONLINE
5 ONLINE
6 ONLINE
7 ONLINE
8 ONLINE
9 ONLINE
10 ONLINE
11 ONLINE
FILE# STATUS
---------- -------
12 ONLINE
13 ONLINE
14 ONLINE
15 ONLINE
16 ONLINE
17 ONLINE
18 ONLINE
19 ONLINE