Re: Oracle error when create a table

From: Sanjay Raj <rsanjaynj_at_yahoo.com>
Date: 24 Apr 2002 11:48:02 -0700
Message-ID: <9f767483.0204241048.77a19a01@posting.google.com>

Tom Cat <noname_at_nosite.com> wrote in message news:<3CC54C78.1C6813D7_at_nosite.com>...
> When I try to create a table I get to following error:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01654: unable to extend index SYS.I_FILE#_BLOCK# by 10240 in
> tablespace
> SYSTEM
> ORA-27059: skgfrsz: could not reduce file size
> Linux Error: 22: Invalid argument
> Additional information: 1
>
> Does anyone know what is and/or how solve the problem?
> Thanx in advance foe your help.
>
> Bye
>
> XXX
Are you trying to create a tble in the SYSTEM tablespace ?? This is BAAAAAAD. Log in as a user with DBA privileges and ALTER USER ( the iser creating the table) DEFAULT TABLESPACE <any tablespace other than SYSTEM/ROLLBACK/TEMP> Alternatively you can specify the tablespace in which Oracle will create the table in the CREATE TABLE command

For Example

    CREATE TABLE testtable

(id       number(10) constraint pk_testtable PRIMARY KEY,
name      varchar2(30),
address   varchar2(30),
city      varchar2(20),
zip       number(10))

tablespace <tablespace_name>
storage (initial 100m next 100m pctincrease 0)

Thanks Received on Wed Apr 24 2002 - 13:48:02 CDT