Help with the sql statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help with the sql statement

Author

Topic

farooqirfan12
Starting Member

1 Post

Posted - 2014-12-10 : 12:42:09

select 'set newname for datafile '||file_id||' to ||chr(39)||replace(file_name,'SourceDB','DestDB')||chr(39)||';'
as "New DB File Names" from dba_data_files
union
select 'set newname for tempfile '||file_id||' to '||chr(39)||replace(file_name,'SourceDB','DestDB')||chr(39)||';'
as "New DB File Names" from dba_temp_files;

ORA-01756: quoted string not properly terminated

farooq

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-12-10 : 13:22:10

Looks like an Oracle error. This is a sql server forum

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources