System Tables Views Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Tables Views
  4. Query v$controlfile table
SQL> select 'cp '||name||' .'  from v$controlfile;
'CP'||NAME||'.'
--------------------------------------------------------------------------------
cp C:\ORACLEXE\ORADATA\XE\CONTROL.DBF .