Check the block sizes. That part of the argument might still stand.
On 2003.07.27 02:24, Saira Somani wrote:
We are using 32-bit on 5L. I don't think Oracle 8.1.7
is compatible with 64-bit AIX kernel.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Your 1652 error means the following:
01652, 0,
There is a 64 bit version of Oracle 8.1.7 for AIX available. Check your
$ORACLE_HOME/lib directory. If you have a lib64 or lib32 directory, then
you have the 64bit version.
RWB
Hi!
I have a suggestion as well:
Tempfiles are sparse files in unix, that is you can use alter tablespace
command to add or resize the files even to 100G if you want, but they don't
actually use much space on disk. When you start writing to this file, OS
tries to allocate more real space to it
Hi Gurus,
After upgrading the OS from AIX 4.3.3 to 5.1, our
Oracle 8i instance is dishing out plenty of ORA-1652
which means that our application cannot commit any
transactions (or so I am finding in my tests).
Help. The warehouse needs to be in production
tomorrow 8AM!
Thanks,
Saira
--
Please
Your 1652 error means the following:
01652, 0, 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.
From the docs...
ORA-01652 unable to extend temp segment by string in tablespace string
Cause: Failed to allocate an extent for temporary segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.
So Check your Temp TBS.
Exactly. However, less than 24 hours ago these queries
(dynamically generated by the application) were
working fine and our TEMP space looked healthy. So I
did what you suggested; now TEMP is 4GB larger than it
used to be, and I'm still running into the same error.
I'm watching the TEMP space fill
We are using 32-bit on 5L. I don't think Oracle 8.1.7
is compatible with 64-bit AIX kernel.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Your 1652 error means the following:
01652, 0, unable to extend temp segment by %s
in tablespace %s
// *Cause: Failed to allocate an extent for temp