Index and order by on Oracle 7.1

From: WANG SHIANG HUEY <wshiang_at_a.cs.okstate.edu>
Date: 1996/10/04
Message-ID: <5345r1$7fh_at_news.cis.okstate.edu>#1/1

Hi, Oracle guru:
I have created an index based on certain key in a table, and tried to run query sort by the field I defined in index, I got message ORA-001652 unable to extend temp segment by ### in tablespace SYSTEM
after browsing documentatin, I increase sort_area_size to 32000 (16382 by default), it still didn't solve the problem. Any body know what that message is all about? SYSTEM tablespace still has more 50% free. Thanks in advance.

-- 
Shiang-Huey Wang
Leather Center, Inc.
sherry_at_leathercenter.com
wshiang_at_a.cs.okstate.edu

Received on Fri Oct 04 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: WANG SHIANG HUEY: "Insufficient privleges"
Previous message: jlazarus_at_execpc.com: "Re: Documentation on SQL and Relational Databases."
Next in thread: John Verhoeven: "Re: Index and order by on Oracle 7.1"
Reply: Dave Mausner: "Re: Index and order by on Oracle 7.1"
Reply: John Verhoeven: "Re: Index and order by on Oracle 7.1"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message