enable constraint

From: <suisum_at_ecn.ab.ca>
Date: 1 Nov 2000 21:29:45 -0700
Message-ID: <3a00edb9@ecn.ab.ca>

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 Received on Wed Nov 01 2000 - 22:29:45 CST