I am using WinXP Home Pro with Oracle Client 9. The oracle server also
ver 9.
I've got an error after long running SELECT query .  The error is
ORA-01652: unable to extend temp segment by 16 in tablespace TEMP

I have a fairly large data set, consisting of slices of points
(essentially in 2-d). Around 100million points in 1million slices.
Points/slice is very skewed (very many with < 10 points, very few >
10000 points).

I'm a pl/sql developer with no access to administrative consoles to
Oracle Database.
I wrote procedure in a package that is used in production environment
from about 3 months. Through our developed logging system (all pl/sql

I've did a program using vb6 to connect to oracle9i, i can establish
the connection, the problem is when i execute the query in oracle
sql*plus, it can execute successfully, but when run in vb application,
the records affected return 0, it do nothing for this query, any

Hi, my table has 2 xml columns and am trying to insert values using
host variables.
insert into xmltab values(XMLType(:H0),  XMLType(:H1))
Unfortunately one of these host variables (or both) is NULL and when

I am using WinXP Home Pro with Oracle Client 9. The oracle server also
ver 9.
I've got an error after long running SELECT query .  The error is
ORA-01652: unable to extend temp segment by 16 in tablespace TEMP

Is there a way to translate words in a column from Afrikaans to
English?
If not, is there a way to check spelling? If so could I separate
misspelled words and insert them in another table (temp table)?

How can I apply DISTINCT only to the first column in this query:
    SELECT  DISTINCT UNIT_ID, BFP_NUMBER, METER_NUMBER
    FROM table_1
It applies it to all 3 fields now. Pls advise.

Please have a look at this query (Just given for guessing
complications).
This query works and gives output for pro_id=1 and other few values.
But it fails for value 2.

Does anybody know how to remove a carriage return
and line feed from text in an sql statement using some function
or combination of functions.
We have a text box in a PHP front end that allows the carriage return to

   I have a problem with xml in PL/SQL
   I am getting an xml schema from an stored prodedure, and supposed
to
use it to generate the new xml document(step1) and hardcode some values

It's been a busy year and I am just now putting a serious effort into
reading Jonathan Lewis's new book "Cost-Based Oracle Fundamentals".
It's a tremendous book and my appreciation goes out to Mr. Lewis for
the time and effort involved in delivering this to the oracle

    I was going throught the Oracle Concepts guide where in it was
described that every server process has its own PGA and PGA consists of
Private SQL area (persistent & runtime area).  The persistent area of
PGA deals with cursors (implicit & explicit).

   I have a Sun Fire V250 with 6X72 GB HDDs. Two of them are mirrored
to each other while the rest are configured as RAID 5. The RAID 5
devices run Oracle 9i and Oracle EBusiness suite. I have been asked to
upgrade to Solaris 10. I have no problem regarding downtime as it is a

The following is working with Oracle 10g R2.
CREATE TABLE hist_group_subgrp_class
(
  sys_date   DATE  NOT NULL,