Re: tablespace SIZE up

It will work, unless you hit the maxdatafiles limit too. See this link for full details :

http://www.jlcomp.demon.co.uk/faq/incr_db_files.html

regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

-----Original Message-----

From: Peter Lintner [mailto:peter.lintner_at_sos-kd.org] Posted At: Tuesday, November 27, 2001 8:09 AM Posted To: server
Conversation: tablespace SIZE up
Subject: Re: tablespace SIZE up

Hi!
In the parameter file initSID.ora the parameter DB_FILES is set to limit the
maximum number of allowed files.
You have to increase this value and restart the DB. Afterwards it will run.
HTH
Peter Received on Tue Nov 27 2001 - 03:11:00 CST