Re: create large index

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 27 Jan 2000 22:40:01 +0800
Message-ID: <389058C1.72FD@yahoo.com>

jieyuan_at_my-deja.com wrote:
>
> I am creating an index on a large table. I got a
> message said can not allocate more space in TEMP
> tablespace. If I do not want to increase the size
> of TEMP tablespace, what should I do? Can I
> divied the creating index process into two
> processes? Thank you
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Find the files for the tablespace using DBA_DATA_FILES

Either add another or extend the existing ones.

This will give more space.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 27 2000 - 08:40:01 CST