RE: How to change the value of MAXDATAFILES of a running instance

From: Jesse, Richard <Rich.Jesse_at_qtiworld.com>
Date: Tue, 30 May 2000 16:36:04 -0500
Message-Id: <10513.107187@fatcity.com>

1. MAXDATAFILES is NOT a valid parameter for your INIT.ORA file. (at least thru 8.0.5)
2. In order to change the value, you MUST recreate your control file(s)!
3. To see your current value,

	SELECT *
		FROM V$CONTROLFILE_RECORD_SECTION
		WHERE TYPE = 'DATAFILE';

	The RECORDS_TOTAL should give you the current value, and
RECORDS_USED is how many you've used.  At  	least they sure are under my

8.0.5 instances!

HTH! :)

Rich Jesse                          System/Database Administrator
rjesse_at_qtiworld.com                 Quad/Tech International, Sussex, WI USA

Disclaimer: Hey, it works for me. It might not work for you!

> -----Original Message-----
> From: ALEMU Abiy [mailto:abiy.alemu_at_criltechnology.com]
> Sent: Tuesday, May 30, 2000 10:56
> To: Multiple recipients of list ORACLE-L
> Subject: How to change the value of MAXDATAFILES of a running
> instance ?
>
>
> Is there somebody who knows how to change the MAXDATAFILES
> parameter value
> of a running database ? If so, I'm really very grateful to
> anyone who can
> explain me.
>
> Thank you friends !!!

---

This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Tue May 30 2000 - 16:36:04 CDT