Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie - Help Extending Cluster

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US