Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>