How to check the datafiles locations if it is in multiple locations ?
select distinct regexp_substr(name,'^.*/') from v$datafile;
select distinct regexp_substr(member,'^.*/') from v$logfile;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