Actually I believe that the problem in this case is that the *temporary*
tablespace for the user is set to USERS and that Oracle is using temp space
during index creation.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
<sybrandb_at_my-deja.com> wrote in message news:8tra1g$kli$1_at_nnrp1.deja.com...
> In article <3a00edb9_at_ecn.ab.ca>,
> suisum_at_ecn.ab.ca () wrote:
> > Hi Ravinder,
> >
> > Thank you very much for your prompt reply.
> >
> > I don't understand why the USERS tablespace is in problem? I have the
> > following tablespace:
> >
> > HOURLY table is in HMR tablespace.
> > Indexes are in HMR_IDX tablespace.
> > If so, What tablespace for the Primary Key?
> >
> > Thanks,
> >
> > ----------
> > From: Ravinder
> > Bahadur[SMTP:Ravinder_Bahadur%SIA-EXT2_at_SINGAPOREAIR.COM.SG]
> > Sent: Wednesday, November 01, 2000 7:29 PM
> > Subject: Re: enable constraint
> >
> > Well you can alter the tablespace and change the
maxextents to
> > a higher number and then before you restart verify the nextentent
sizes
> > for the tablespace a too small size will create a lot of extents very
> > quickly specially if you have large data to work with so increase the
> > sizes as required.
> >
> > Subject: enable constraint
> >
> > I disable the primary key of a table in error.
> >
> > Now I got the following error message. Please help.
> >
> > > alter table HOURLY enable constraint HMR_PK;
> > alter table HOURLY enable constraint HMR_PK
> > *
> > ERROR at line 1:
> > ORA-01630: max # extents (50) reached in temp segment in tablespace
USERS
> >
> >
>
> Apparently you didn't specify a tablespace when creating the constraint
> and your tablespace USERS is your default tablespace.
> To make sure the index associated with a primary key ends up in the
> correct tablespace add
> using index tablespace <tablespace_name> storage <storage_clause>
> In your current situation you can move the index by using
> alter index <index_name> rebuild
> tablespace <correct_tablespace>
> storage <storage_clause>
>
> Hth,
>
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------------------------------
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 07 2000 - 03:10:32 CST
