Newly added datafile is not shown in DBA_DATA_FILES

[samdba]

Hi guys,

8i/Windows NT.

I re-created TEMP tablespace with foll. command

CREATE TEMPORARY TABLESPACE temp
TEMPFILE 'e:\oradata\test\temp01.dbf' SIZE 2048M
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 10M;

select * from dba_Data_files where tablespace_name='TEMP'

returns no rows.

select * from dba_tablespaces where tablespace_name='TEMP'

shows the correct record.

Why it does not show data file temp01.dbf'

Thanks in Adv.

[pando]

it's temporary so you have to look in dba_temp_files