Re: Help: Tablespace full after creating 2 tables and no records.

Steve Perry (dpsmp_at_ix.netcom.com) wrote:
: I created 2 tables in a tablespace (I created) that's 10 meg. When I try
: and create the indexes and primary keys, I get a message that Oracle
: couldn't extend the temp segments.
(snip)

The temporary segments referred to are just that--temporary segments in the user's temporary tablespace. Index creation requires sorting, and a sort that doesn't fit in the SGA sort buffer is done on disk via temporary segments. If you haven't already done so, create a tablespace that's dedicated to such temporary segments, and set each user's temporary tablespace  to it.

--
| Paul Baumgartel                                        |
| Principal Consultant                   (203) 735-3524  |
| Adept Computer Associates, Inc.        paulb_at_pcnet.com |