extension convention for datafiles
Hi,
I observed that you can create a datafile without extension, e.g.:
SQL> ALTER TABLESPACE test_mare ADD DATAFILE 'testdata12' SIZE 10M
On Windows this is seen as file of type FILE and it has no extension.
In this tablespace I also have a datafile named testdata12.dbf, and this is seen as file type .DBF.
1) What is the impact of having datafiles w/o extension? (data are retrieved and file is used till now w/o issues)
2) I searched for a document to present naming convention and possible extensions, but till now I did not find a relevant one.
I observed that you can create a datafile without extension, e.g.:
SQL> ALTER TABLESPACE test_mare ADD DATAFILE 'testdata12' SIZE 10M
On Windows this is seen as file of type FILE and it has no extension.
In this tablespace I also have a datafile named testdata12.dbf, and this is seen as file type .DBF.
1) What is the impact of having datafiles w/o extension? (data are retrieved and file is used till now w/o issues)
2) I searched for a document to present naming convention and possible extensions, but till now I did not find a relevant one.
0