Managing Oracle Database Data Files: Relocation and Renaming Techniques
Querying Data Files
col name format a60
set pagesize 9999
select ts#,file#,name,status from v$datafile d where d.status!='ONLINE' ;
select * from v$tablespace;
Important Considerations
When relocating or renaming data files for SYSTEM, SYSAUX, and UNDO tablespaces, it is highly recommended to perform these operations with the database shut d ...
Posted on Thu, 15 Oct 2026 16:53:21 +0000 by rpupkin77