Re: Newbie - Help Extending Cluster

From: Dante <dnotari_at_my-dejanews.com>
Date: Sat, 15 May 1999 23:34:00 GMT
Message-ID: <7hl098$o8p$1@nnrp1.deja.com>

Paul,
you (or who ever) created the cluster in the SYSTEM tablespace. This is not a wise decision.

If you use the CREATE CLUSTER statement without specifing a tablespace it gets created in the default tablespace of the user (this applies to all objects). The default tablespace is by default, if you don't specify one for the user on creation or by altering, the SYSTEM tablespace.

The SYSTEM tablespace should only be used for the DB datadictionary.

What next ? Drop the cluster and recreate it in a different tablespace. alter your users so they are creating their objects in the SYSTEM tablespace.

Why can the cluster not extend ? many reasons ... not enough space, not more extents

Regards
Dante

In article <373d6978_at_newsread3.dircon.co.uk>, "Paul Davies" <cobalt_at_dircon.co.uk> wrote:
> I'm trying to insert data into a table and am getting the following
error:
>
> Can't execute statement: ORA-01655: Unable to extend cluster
SYSTEM.C_CLUS_1
> by 710 in tablespace SYSTEM
>
> How do I extend the cluster?
>
> Help appreciated
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Sat May 15 1999 - 18:34:00 CDT