Resize and rename data files

Rename

To rename a file in Oracle.

alter database rename file 
  'D:\ORACLE\PRODUCT\19\ORADATA\ORCL\CALWIN.DBF' 
to
  'c:\ORACLE\PRODUCT\19\ORADATA\ORCL\CALWIN.DBF';

Resize

alter database 
  datafile 'E:\ORACLE\PRODUCT\19\ORADATA\ORCL\USERS01.DBF'
  resize 500M;

Last updated

Was this helpful?