This query give the list of the different datafile:

SELECT fil.FILE_NAME FROM dba_data_files fil

:D/Oracle.......

this query give me where the database is running

SELECT SYS_CONTEXT('USERENV','TERMINAL') FROM dual;

On the same serveur, I'm searching the datafiles. in :D/. But there is no subfolder Oracle.

I've searched with explorer and with powershell:

 Get-ChildItem D:\ -Hidden

Why?

CodePudding user response：

to get the server name. replace TERMINAL by SERVER_HOST

 select sys_context('USERENV','SERVER_HOST') from dual