Wednesday, March 23, 2022

How to find out the locations of CRD files in Oracle

How to find out the locations of CRD files in Oracle


SQL> select distinct regexp_substr(name,'^.*/')from v$datafile;         

SQL> select distinct regexp_substr(member,'^.*/') from v$logfile;          

SQL> select distinct regexp_substr(name,'^.*/') from v$controlfile;                                                 

select name from v$datafile;
select name from v$controlfile;
select member from v$logfile;

No comments:

Post a Comment