Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1KEgre07071 for ; Fri, 20 Feb 2004 08:42:53 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1KEgqo07064 for ; Fri, 20 Feb 2004 08:42:52 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D5EBD395974; Fri, 20 Feb 2004 09:40:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 20 Feb 2004 09:39:28 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from bristol24.audit-commission.gov.uk (mailhost.audit-commission.gov.uk [193.128.236.210]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BBB0439589F for ; Fri, 20 Feb 2004 09:39:06 -0500 (EST) Received: from bristol21.bristol.ac (unverified) by bristol24.audit-commission.gov.uk (Content Technologies SMTPRS 4.3.6) with SMTP id for ; Fri, 20 Feb 2004 14:41:03 +0000 Received: from AC-Message_Server by bristol21.bristol.ac with Novell_GroupWise; Fri, 20 Feb 2004 14:34:00 +0000 Message-Id: X-Mailer: Novell GroupWise Internet Agent 5.5.5.1 Date: Fri, 20 Feb 2004 14:33:38 +0000 From: "Niall Litchfield" To: Subject: RE: Shooting yourself in the spfile Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Content-Disposition: inline X-archive-position: 1393 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: n-litchfield@audit-commission.gov.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l I'd buy that if it wasn't so easy to do what Jonathan said for example SQL> alter system set db_cache_size=3D50m scope=3Dspfile; System altered. SQL> alter system set db_block_buffers=3D2000 scope=3Dspfile; System altered. SQL> startup force; ORA-00381: cannot use both new and old parameters for buffer cache size spe= cification SQL> oops Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805=20 ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------