Move and rename datafiles (and all oracle files)

Create new files system paths if they not exists
See Db files and path scripts

 

Move tempfiles

Tempfiles cannot be renamed(9i), so drop and recreate them

 

Manually check if controlfiles need rename in init.ora

Save this result [moves]:
select 'mv ' || file_name || ' ' || replace(file_name, '/ora02_gene', '/ora01_gene') mv
from (
  select * from (
      select file_name from dba_data_files
      union all
      select member from v$logfile
  ) 
)
where file_name like '/ora02_gene%' 
order by 1

Save this result [rename]:
select 'alter database rename file ''' || file_name || ''' to ''' || replace(file_name, '/ora02_gene', '/ora01_gene') || ''';' rename_file from (
  select * from (
      select file_name from dba_data_files
      union all
      select member from v$logfile
    ) 
)
where file_name like '/ora02_gene%' 
order by 1

Shutdown instance

move physically the files [moves]

startup mount

run rename [rename]