 | |
| ORA-01652 | | ORA-01652: | unable to extend temp segment by string in tablespace string | | Cause: | Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated. | | Action: | Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. |
|
|
| Posts about ORA-01652 | | Hello
I would like to ask you about after servererror trigger. I wrote trigger as
below
CREATE OR REPLACE TRIGGER notification_error
after servererror on database
declare
d_sender vAny other differences besides 1) does not lock the table 2) does a full table scan instead of full index scan ?
-----Original Message-----
From oracle-l-bounce@(protected) [mailto oracle-l-bounSQL > alter index "SAPR3 ". "VBFA~0 " rebuild online parallel 3 tablespace PSAPREROGI
*
ERROR at line 1
ORA-12801 error signaled in parallel query server P001
ORA-01652 unable to extend temp segment bDoes anyone know where to find information related to how increase the
necessary temporary space when I increase the parallel degree?
We have a large data warehouse (20Tb). and lately some ORA-01652 from v$lock l
*
ERROR at line 14
ORA-01652 unable to extend temp segment by 128 in tablespace TEMP
that is an expensive statement to execute.
I think that some chi Andrew V Zitelli
the EVENT# like sqlcode for example
select count(*) from (select * from member order by member_level)
*
ERROR aOracle 8.1.7 Solaris 9.
A developer brought me a pl/sql procudure that had a select /*+RULE*/
hint in it. It was performing poorly (to the point of blowing out temp
space with an ORA-01652 errorIf your TEMP tablespace is extending up to 18 GB and you try to lock it down to a smaller size aren 't you setting yourself up for ORA-01652 unable to extend temp segment by XXX in tablespace TEMP er |
|
| Oracle Database Server Error Codes | |
|