Re: modify the location of control files

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Wed, 11 Jun 2003 15:51:47 -0500
Message-ID: <pb5fev0hmmooklqemssav2d383bi9909i7@4ax.com>

This should work:

Create a pfile from the spfile( create pfile from spfile command) ,shutdown, move the file(s), edit the pfile to modify the file specs , use the new pfile to startup ( specifying pfile=newpfileyou_just_ created) , create a new spfile ( create spfile from pfile) , shutdown and restart.

hth,

"Gordon T. Wu" <wutao19_at_yahoo.com> wrote:

>Hi Group:
>
>I'm trying to multiplex the locations of control files. How do I
>change the location of CONTROL03.CTL in Oracle 9.2? The spfile thing
>in Oracle 9.2 is making this process complicated.
>
>Thanks a lot.
>

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Jun 11 2003 - 15:51:47 CDT