Problem with tablespace file size limit

[jstuglik]

Hi.
I have a problem with tablespace file size limit. I use Oracle 11g
Standard Edition One on Fedora 8 Linux (x86_64).
The linux file system is ext3 with 4096 bytes blocks (which gives 2TiB
max file size). User oracle (on which the RDBMS runs) has no limits
set for a max file size (unlimited). The tablespace has also unlimited
extends set and the block size is set to 8192 bytes. Nevertheless I
encountered a problem with extending tablespace file size past 32GB.
The exact error was:

ORA-01654: unable to extend index XXX.SYS_C0011327 by 8192 in
tablespace XXX

The index is a primary key index on one of the tables. The tablespace
datafile size is now 34359730176 bytes, hence extending it by another
8192 bytes would give exactly 32GB of data.
Just to be sure I also checked if there is a possibility of creating
file sized more than 32GB on user oracle and it succeeded (I used cat /
dev/zero > aa).
The query from user_tablespaces shows that tablespace max size is
2147483645 with 8192 block size so it is way more than 32GB. It is
also standard SFT.
Oh, before you ask, there is plenty of free space on disk.

Do you have any ideas?
Please help me ASAP because now the system is running only because I
dropped one of the less important indices but it will fill up again in
short time.

[ddf]

Asked, and answered, in another forum.


David Fitzjarrell

[walia anand]

add file on some other disk in same tablespace



WALIA

[ddf]

> > short time.- Hide quoted text -
>
> - Show quoted text -

An answer already supplied in a different newsgroup for this exact
question:

http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/dd4cc0f6becb9aab


David Fitzjarrell

[Agustin Utrera Narro]

The max size of the datafiles is 32 GB.

Add a new datafile to the tablespace and modify the actual datafile for not extend.

Agustín Utrera
Think twice before printing.
(Any help with my english is welcome. Please, correct me)

Stephen Leacock  - "I detest life-insurance agents: they always argue that I shall some day die, which is not so."

2009/8/20 jstuglik <jakub....@gmail.com>

[ddf]

On Aug 24, 6:11 am, Agustin Utrera Narro <agus....@gmail.com> wrote:
> The max size of the datafiles is 32 GB.
> Add a new datafile to the tablespace and modify the actual datafile for not
> extend.
>
> Agustín Utrera
> Think twice before printing.
> (Any help with my english is welcome. Please, correct me)
>

> Stephen Leacock<http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html>

> - "I detest life-insurance agents: they always argue that I shall some
> day
> die, which is not so."
>

> 2009/8/20 jstuglik <jakub.stug...@gmail.com>

>
>
>
>
>
> > Hi.
> > I have a problem with tablespace file size limit. I use Oracle 11g
> > Standard Edition One on Fedora 8 Linux (x86_64).
> > The linux file system is ext3 with 4096 bytes blocks (which gives 2TiB
> > max file size). User oracle (on which the RDBMS runs) has no limits
> > set for a max file size (unlimited). The tablespace has also unlimited
> > extends set and the block size is set to 8192 bytes. Nevertheless I
> > encountered a problem with extending tablespace file size past 32GB.
> > The exact error was:
>
> > ORA-01654: unable to extend index XXX.SYS_C0011327 by 8192 in
> > tablespace XXX
>
> > The index is a primary key index on one of the tables. The tablespace
> > datafile size is now 34359730176 bytes, hence extending it by another
> > 8192 bytes would give exactly 32GB of data.
> > Just to be sure I also checked if there is a possibility of creating
> > file sized more than 32GB on user oracle and it succeeded (I used cat /
> > dev/zero > aa).
> > The query from user_tablespaces shows that tablespace max size is
> > 2147483645 with 8192 block size so it is way more than 32GB. It is
> > also standard SFT.
> > Oh, before you ask, there is plenty of free space on disk.
>
> > Do you have any ideas?
> > Please help me ASAP because now the system is running only because I
> > dropped one of the less important indices but it will fill up again in

> > short time.- Hide quoted text -
>
> - Show quoted text -

Again, this information has already been supplied in the thread listed
in my prior post.


David Fitzjarrell