Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Value of MAXDATAFILES

Re: Value of MAXDATAFILES

From: Reinhard Wahl <wahl_at_zv.fhg.de>
Date: Wed, 28 Apr 1999 17:34:44 +0200
Message-ID: <37272A94.6337DE44@zv.fhg.de>

> Is there any way to get the value of MAXDATAFILES from the database (NOT
> using 'alter database backup controlfile to trace) ??

Yes, there is:

SELECT * FROM v$parameter where name = 'db_files';

returns 'max allowable # db files' (=description)

Hope this helps

Reinhard


    Hiermit widerspreche ich der Nutzung oder    Uebermittlung meiner Daten fuer Werbezwecke    oder fuer die Markt- oder Meinungsforschung   gemaess Par. 28 Abs. 3 Bundesdatenschutzgesetz.



Please do not use my E-Mail address for advertising!
Received on Wed Apr 28 1999 - 10:34:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US