Query v$dbfile table : V_dbfile « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. V_dbfile

Query v$dbfile table

 

SQL> select 'cp '||name||' .'  from v$dbfile;

'CP'||NAME||'.'
--------------------------------------------------------------------------------

cp C:\ORACLEXE\ORADATA\XE\USERS.DBF .
cp C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF .
cp C:\ORACLEXE\ORADATA\XE\UNDO.DBF .
cp C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF .
cp C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\DATA_1A.DBF .
cp C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\DATA_1B.DBF .

6 rows selected.

SQL>
SQL>

   
  

Related examples in the same category