Re: Error ORA-1652 in Oracle 7

From: Mike Morgan <mike.morgan_at_teldta.com>
Date: 1995/09/06
Message-ID: <42l216$p4f_at_madison.tdsnet.com>#1/1

cuppettm_at_richmond.infi.net (Mike Cuppett) wrote:
>Does anyone know where this error message is documented? The error
>occurred because the system was unable to extend a tmp segment by 512 in
>one of the tablespaces. I have resolved the problem but would like to be
>able to reference the error code if it occurs again. I was unable to
>find this error message explained in the Oracle 7 Server Administrator's
>Guide or the Unix Administrator's Reference. Thanks!
>--
>Michael S. Cuppett
>cuppettm_at_richmond.infi.net
>Oracle Database Manager
>Department of Information Technology
>City of Richmond, Virginia
>

Michael,

You mentioned the Unix Administrator's Reference. I assume you are in a Unix environment (Sun, HP, AIX, etc.) If so, at the OS prompt you can use the oerr utility to resolve ORA-xxxx error messages.

Here's an example in our environment:

[pythia:oracle]: oerr ora 1652
01652, 00000, "unable to extend temp segment by %s in tablespace %s"

// *Cause:  Failed to allocate an extent for temp segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//         files to the tablespace indicated.

Hope this helps.

---

Mike Morgan
Technology Integration Services - Unix DBA

email: Mike.Morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705 USA
(608)845-4661

"The DBA is always right ... even when [s]he's wrong."

---

Received on Wed Sep 06 1995 - 00:00:00 CEST