Re: 8.5 GB tablespace

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 4 Mar 2002 07:29:29 +1100
Message-ID: <a5u13e$q7i$1@lust.ihug.co.nz>

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" <user_at_debian.pl> wrote in message
news:slrna851cf.445.user_at_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

Received on Sun Mar 03 2002 - 14:29:29 CST