Brian: I am currently using SPFILE on my 9.2.0.5 production environment. As an additional request from the experts: I keep my INIT.ORA files around in case I want to adjust my instance parameters, (I just edit the INIT.ORA and recreate the SPFILE). Is there any easier way to do this?? Thanks Rick Weiss Oracle Database Administrator Technical Services Bureau Central Services Division MT Dept of Labor & Industry Helena, MT Phone: (406) 444-9628 E-Mail: rweiss@xxxxxxxxxxx -----Original Message----- From: Spears, Brian [mailto:BSpears@xxxxxxxxxxxxxxxxx] Sent: Friday, September 24, 2004 9:17 AM To: oracle-l@xxxxxxxxxxxxx Subject: 9i poll on spfile feature Just wanted to see what people have resorted to using in real world practice with the spfile. With 9i, are you still using the init file or have you migrated to using the spfile ? If still using the Init file.. What is the main reason for continuing to using the init file. Brian -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l