Re: ORA-01654

Sorry, I want to be exact on this before I execute. Kinda nervous doing this since I am a newbie.

In SQL I enter this?

Can this table be called anything ... like system1? When I do the alter table system1 move .... what am I moving?

> create a second tablespace
> and issue
> alter table <table_name> move ....
> and
> alter index rebuild .tablespace ...

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:h47ko1980mlp84qrnooimm0a3koo125qf0_at_4ax.com...
> On Sun, 27 Nov 2005 19:23:24 GMT, "Shredder" <shred_at_shredder.com>
> wrote:
>
>>I am not very knowledgeable with Oracle and I am getting this error mesage
>>when trying to save data into our MRP database. The transactions are
>>issued
>>using a front end to Oracle called Obvious MRP. I am running Oracle 8i on
>>a
>>Netware 5.1 Server. I have verified that I have 15GB of free space on my
>>Volume. Can anyone give me any suggestions?
>>
>>Thanks in advance,
>>Brian
>>
>>ORA-01654: unable to extend index SYSADM.OPS_TRANS_IDX1 by 138254 in
>>tablespace SYSTEM ORA-27039: create file failed, file size limit reached
>>OSD-02067: illegal option specified
>>
>
> First of all, do NOT create end-user objects in the SYSTEM tablespace
> EVER.
> Secondly, the error messages are quite clear
> 1 index needs to be extended, and can't be extended
> 2 The tablespace needs to extend, and this can't be done because the
> size of the file reached a fixed Netware imposed limit.
> Cure: you need to add another datafile to this tablespace,
> but better still:
> create a second tablespace
> and issue
> alter table <table_name> move ....
> and
> alter index rebuild .tablespace ...
> commands.
>
> Then of course: consult the manuals before creating havoc.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Tue Nov 29 2005 - 12:11:08 CST