Wednesday, September 1, 2010

ORA-01652: unable to extend temp segment by 1024 in tablespace

You may get this error when you create any object due to the tablespace is full where the objects is beign created. The possible solution.
(1). Extend the tablespace currently beign used by the objects (Schema).
To extend you should need the dba priveleges. Even if you are granted the neccessary privileges , you may have to bounce the db to reflect your changes.

(2) As a developer you may try this.
(a). Find out the autoextendable tablespaces
SELECT TABLESPACE_NAME
FROM DBA_DATA_FILES
WHERE autoextensible='YES';

(b) Apply the table space in the create table syntax

create table test TABLESPACE
as
select *
from all_objects;