*CREATE PFILE* [= 'pfile_name'] *FROM* SPFILE [= 'spfile_name'];
Will create a pfile from the current content of thr spfile :-)
CHEN,JIN wrote:
Hi there,
I found my SPFILE and PFILE are pointing to the same one that is spfile<SID>.ora. Now, I want to multiplex control file and books tell me to change in init<SID>.ora. I wonder how can create a init<SID>.ora from SPFILE. I knew there is one in $ORACLE_BASE/admin/<SID>/pfile when I created database. But I might change some parameters by "alter database ..." or "alter system ...", like changing to ARCHIVELOG and multiplexing redo log. I am not sure if current spfile is different from that init<SID>.ora.
Please help! thanks, Jin
-- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk
Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html
Miracle Master Class with Tom Kyte, 12-14 January 2004
smime.p7s
Description: S/MIME cryptographic signature
