Skip to content

Instantly share code, notes, and snippets.

@freddenis
Last active Jul 27, 2016
Embed
What would you like to do?
rename_a_dg_24
SQL> set lines 200
SQL> set pages 999
SQL> select 'alter database rename file ''' || name || ''' to ''+DATA' || substr(name,instr(name,'/',1,1)) || ''';' from v$datafile ;
...
SQL> select 'alter database rename file '''|| member ||''' to ''+DATA' || substr(member,instr(member,'/',1,1)) || ''';' from v$logfile;
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment