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?