Temp Table Space "no rows selected"

I am trying list files in temp table space. but It says “no rows selected” Please explain why I am not getting the file added to the table space.

CREATE TEMPORARY TABLESPACE TESTRM;
Tablespace created.

ALTER  TABLESPACE TESTRM ADD TEMPFILE '+TESTDATA/rm/datafile/TESTRM_temp01.dbf' SIZE 2M;
Tablespace altered.

SQL> SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'TESTRM';
no rows selected


Source: oracle

Leave a Reply