Oracle Error

[nread]

Would someone please explain to me why i get the following errors whe running a simple query i am using to highlight duplicates....

ORA-12801 error signaled in parrallel query server P024
&
ORA-01651 unable to extend temp segment by 3200 in tablespace TEMPORARY1

Grateful for any comments

Cheers
Nread

 

[alexhu]

Are you sure that second error is not ORA-1650?

ORA-01650: unable to extend rollback segment name by num in tablespace name
Cause: Failed to allocate extent for the rollback segment in tablespace.

Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace.


It means you do have enough contiguous free space in the tablespace TEMPORARY1

Alex

 

[alexhu]

Just igmore that last post (pity we can't edit them really )

The answer is still the same

It means you do have enough contiguous free space in the tablespace TEMPORARY1

Alex

 

[alexhu]

I think I'll just give up now

It means you do NOT have enough contiguous free space in TEMPORARY1

Alex

 

[nread]

The second error is definately 01652, doesn't this sound right...??

Cheers
Nick

 

[alexhu]

Well............ You've got ORA-01651 in the first post !!

The answer is still the same, the solution is either restart the instance to clear down temporary segments or add a data file to the temp tablespace

Alex

 

[KenCunningham]

Just look, it's Halloween and obviously the gremlins have been at work on this thread! ;-)

Cheers.

 

[nread]

Thanks people, i'll take all reponses into account....

Nread