Single Quotes and rman sql Command 1

[Michael42]

Hello,

On a Solaris 8 system running Oracle 9i I am having a problem with one of my rman commands.

run {
sql 'create pfile='/mydir/initTEST.ora' from spfile';
...
}

I does not like the single quotes for the pfile= parameter. I have tried "" and other variations.

What can you recommend?

Thanks,

Michael42

 

[SantaMufasa]

Michael,

Have you tried to successive single quotes (like in SQL to create a single quote)?:

run {
sql 'create pfile=''/mydir/initTEST.ora'' from spfile';
...
}

I am not an rman aficionado, so I don't know if this will help, but it couldn't give you a worse result than it already gave you.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Michael42]

>> Have you tried to successive single quotes

Yes. :-(


Any other suggestions?

Thanks,

Michael42

 

[lewisp]

Like Santa I do not know rman, but will

run {
sql 'create pfile="/mydir/initTEST.ora" from spfile';
...
}

or

run {
sql "create pfile='/mydir/initTEST.ora' from spfile";
...
}

work?

 

[stefanhei]

Both quite near:

run {
sql "create pfile=''/mydir/initTEST.ora'' from spfile";
...
}

works.

Stefan

 

[SantaMufasa]

...but don't "quote" me on this...

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Michael42]

stefanhei,

That nailed it!

Thanks for posting. I think we were all pretty close...but I will not quote Santa!

Thanks,

Michael42