-
SP File and pfile
hi,
My Oracle DB is starting using the "SPFILEORACLE".
But i want to change this PFILE.
How to i cahnge the Sp File to Pfile?
Thanks & Regards
Prasad KVV
Venkata vara Prasad Kosaraju
-
create pfile from spfile;
shutdown
remove spfile
startup
have to ask why though, spfiles are generally a good thing
-
Originally posted by davey23uk
remove spfile
Why remove, cant it be done with out doing so??
When it can be, then why remove?
BTW, prasad please RTM
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
because if you dont remove it and just do 'startup'
it will use the spfile, which the op doesnt want
-
Originally posted by davey23uk
because if you dont remove it and just do 'startup'
thas known.. so use pfile = 'path of pfile' is wat i meant in my previous post..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|