Path: news.easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.digex.net!intermedia!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!news!newsfeeds.ihug.co.nz!lust.ihug.co.nz!ihug.co.nz!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server Subject: Re: 8.5 GB tablespace Date: Mon, 4 Mar 2002 07:29:29 +1100 Organization: ihug ( New Zealand ) Lines: 45 Message-ID: References: NNTP-Posting-Host: p254-tnt8.syd.ihug.com.au X-Trace: lust.ihug.co.nz 1015187374 26866 203.173.147.254 (3 Mar 2002 20:29:34 GMT) X-Complaints-To: abuse@ihug.co.nz NNTP-Posting-Date: Sun, 3 Mar 2002 20:29:34 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.server:137312 X-Received-Date: Sun, 03 Mar 2002 13:40:54 MST (news.easynews.com) Please include error *text* as well as numbers (not everyone has the ability to do an 'oerr ora xxxx' to see what the numbers mean). In this case, I think you are hitting either an O/S limitation in the possible size of datafiles, or an internal Oracle error based on the fact that, however big the files may be physically, Oracle can only address a certain number of blocks (I suspect the latter). Solution: try creating multiple smaller datafiles. If you want an 8Gb tablespace, create it with 4 2Gb datafiles. If you've already got the tablespace created, that's just "alter tablespace blah add datafile '/x/y/file2.dbf' size 2000m;" as many times as necessary. Regards HJR -- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "Marcin Jakubowski" wrote in message news:slrna851cf.445.user@herse.loc... > > Hello > > I have Redhat 7.1 and oracle 8.1.7 on it. I cant create 8.5 GB tablespace > > ORA-19502 > ORA-27069 > > My block size is 16384. I have second 20 GB disk for data and it was firs of > all my data tablespaces so I have disk space for it. > > Tia > > > -- > Marcin Jakubowski > Ambient, > www.ambient.com.pl