Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query v$controlfile table

SQL> select 'cp '||name||' .'  from v$controlfile; 'CP'||NAME||'.' -------------------------------------------------------------------------------- cp C:\ORACLEXE\ORADATA\XE\CONTROL.DBF .