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