Oracle Datafile Migration.
ora.jpg

-- Select Datafile:
select name from v$datafile;

-- Mount Connect:

shutdown immediate
startup mount
connect Password/User@SID as sysdba

-- Rename Datafile:

alter database rename file 'C:\Oradata\users01.dbf' to 'E:\Oradata\users01.dbf';
    

Kopieren