Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!g38g2000yqd.googlegroups.com!not-for-mail From: Charles Hooper Newsgroups: comp.databases.oracle.server Subject: Re: Hit 4GB file size limit in Oracle 9.2.0.1.0 on W2003 Date: Fri, 12 Dec 2008 04:44:50 -0800 (PST) Organization: http://groups.google.com Lines: 33 Message-ID: <64ee4dbb-2186-49bc-8c97-1e4a2899136b@g38g2000yqd.googlegroups.com> References: NNTP-Posting-Host: 65.118.7.2 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1229085891 9953 127.0.0.1 (12 Dec 2008 12:44:51 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 12 Dec 2008 12:44:51 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: g38g2000yqd.googlegroups.com; posting-host=65.118.7.2; posting-account=xVXeFwkAAAAz3xgWc6VZyjXxx1jx4jb4 User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Dec 12, 5:52=A0am, stephenmor...@btinternet.com wrote: > Please could anybody help. =A0A friend has a corrupted database. =A0She > has execeed 4GB on the size of a datafile. =A0She has been told she will > need patch 2585700 and will have to restore her database. =A0I must > admit I was not aware of this problem. > > I would be gratefull for any information, if anybody has experience of > this problem. =A0She want to be sure she is doing the right thing to > solve the problem. > > Thanks in advance. > > Best wishes, Stephen. Something does not seem correct. There is a 4GB per partition limit if the hard drive is formatted with the old style FAT type format, and a 4GB per file limit if the hard drive is formatted with a FAT32 type format. If the hard drive is formatted with a NTFS type format, the maximum data file size is limited by the maximum number of blocks permitted by Oracle, about 4 million blocks, and if the database is using an 8KB block size, that limits the maximum data file size to about 32GB on Oracle 9.2.0.1 when running on Windows 2003: http://download.oracle.com/docs/cd/B10501_01/server.920/a96536/ch43.htm#287= 916 A search of Metalink does not find that patch number, but an advanced search does find bug 2585700 which is apparently fixed in Oracle 9.0.1.4.0 and in 9.2.0.2. So, it appears that your friend needs a Metalink account to download the 9.2.0.2 or a more recent patch set. Charles Hooper IT Manager/Oracle DBA K&M Machine-Fabricating, Inc.