file size

From: Greg Faktor <FAKTORG_at_wyeth.com>
Date: Thu, 27 Jan 2005 13:53:46 -0500
Message-Id: <s1f8f279.000@gvn002m.gv.us.pri.wyeth.com>

Hi All!

What is disadvantage to have one 25-30 GB datafile on Win 2000 and Oracle 9i instead of 7x4GB? I have one application where if they're more then 1 datafile then app manager can't see tablespace free space. Do not ask why, this is the way application is designed. I don't want app people to connect to the database using anything but application. Now I need to make strong point to convince then that having one big file is not good idea. Any suggestions?

Thanks.
Greg

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 27 2005 - 13:56:36 CST