OraFAQ Forum: Backup & Recovery » scripting setnew name for datafile 1 to

Home » RDBMS Server » Backup & Recovery » scripting setnew name for datafile 1 to

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

scripting setnew name for datafile 1 to [message #290592]

Sun, 30 December 2007 04:54

hrishy
Messages: 25
Registered: August 2005

Junior Member

Hi

Does anybody have a script that dynamically generates the RMAN script

setnew name for datafile 1 to

from sqlplus and spools it to file which i can later edit.

I require this for duplication of my database where the file systems don't match between source and target database and also the sizes of the file systems are vastly different

regards
Hrishy

Report message to a moderator

Re: scripting setnew name for datafile 1 to [message #290605 is a reply to message #290592]

Sun, 30 December 2007 09:11

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

spool myfile
set feedback off
set heading off
set linesize 500
set trimspool on
select 'setnew name for datafile 1 to' from dual;
spool off

Regards
Michel

Report message to a moderator

Re: scripting setnew name for datafile 1 to [message #290612 is a reply to message #290592]

Sun, 30 December 2007 11:24

hrishy
Messages: 25
Registered: August 2005

Junior Member

Hi Michel

Than you very much i appreciate the effort answering my question on a sunday.

I was looking for a script that is generic and can work on a any database when i do a duplication.

Wish you a very happy new year