OraFAQ Forum: Server Administration » Why cant the SYSTEM tablespace extend?

Home » RDBMS Server » Server Administration » Why cant the SYSTEM tablespace extend? (RDBMS 10.2.0.3, HPUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why cant the SYSTEM tablespace extend? [message #448102]

Fri, 19 March 2010 08:27

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

The SYSTEM tablespace refuses to autoextend (3 segments in SYSTEM tablespace unable to extend). It sits on its current size of 559MB (auto set to 2GB, increment 10M).

I guess there are no free extends that are that big as 10M.

But how do I solve this?

Regards
H

Report message to a moderator

Re: Why cant the SYSTEM tablespace extend? [message #448105 is a reply to message #448102]

Fri, 19 March 2010 08:34

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

First we would have to ask what object is it that is trying to extend? I hope it is not a user created object as nothing should be put in the SYSTEM tablespace.

And yes, you do not have a 10Mb contiguous chunk.

Report message to a moderator

Re: Why cant the SYSTEM tablespace extend? [message #448106 is a reply to message #448102]

Fri, 19 March 2010 08:38

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

This are the objects: INDEX SYS.PK_C0, INDEX SYS.PK_CT, INDEX SYS.PK_CS

So its seems its not a user that have messed up.

Regards
H

Report message to a moderator

Re: Why cant the SYSTEM tablespace extend? [message #448108 is a reply to message #448106]

Fri, 19 March 2010 08:44

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What are table names that those indexes belong to? Are those tables meant to be created in SYS schema?

Report message to a moderator

Re: Why cant the SYSTEM tablespace extend? [message #448110 is a reply to message #448108]

Fri, 19 March 2010 08:53

hristo
Messages: 258
Registered: May 2007

Senior Member

They belong to the following tables:

SYS.PK_C0 = DBMS_UPG_CAT_C0$
SYS.PK_CT = DBMS_UPG_CAT_CT$
SYS.PK_C0 = DBMS_UPG_CAT_CS$

Regards
H

Report message to a moderator

Re: Why cant the SYSTEM tablespace extend? [message #448120 is a reply to message #448102]

Fri, 19 March 2010 10:46

hristo
Messages: 258
Registered: May 2007

Senior Member

I turned off autoextend and resized the datafile, the error is gone. I guess Oracle needs enough space on disc (which it did not have) for ALL the autoextend before extending (in this case 2GB).

Regards
H

Report message to a moderator

Previous Topic:	OS_CPU_WAIT_TIME AND PHYSICAL_MEMORY_BYTE
Next Topic:	What Oracle EE options are in use - License compliance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 08:48:13 CDT 2024