Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datafile without .dbf extension

SujoyJul 21 2008 — edited Jul 21 2008

Hi Everyone,

SQL> SELECT file_name FROM  dba_data_files t WHERE t.tablespace_name='APPS_TS_TX_IDX';

FILE_NAME
--------------------------------------------------------------------------------
+DATA/prdzccbn/datafile/apps_ts_tx_idx.274.616700509
+DATA/prdzccbn/datafile/apps_ts_tx_idx.285.616700867
+DATA/prdzccbn/datafile/apps_ts_tx_idx.277.616700615
+DATA/prdzccbn/datafile/apps_ts_tx_idx.278.616700651
+DATA/prdzccbn/datafile/apps_ts_tx_idx.276.616700579

Can anyone explain why there are no datafiles with .dbf extension in the above query? Also, are the above files actual datafiles?

Regds,
Sujoy

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2008

Added on Jul 21 2008

#general-database-discussions

7 comments

1,938 views