Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-1652 during insert , should be ORA-01653 ?

698658Mar 5 2010 — edited Mar 8 2010
Developer provided me with log where :
ORA-01652: unable to extend temp segment by 64 in tablespace TBS

Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO TABLE.... VALUES(?,?,?)
table is empty tbs is 30 GB free .
insert is using values (so no insert from select) .
I did some tests and in my opinion the ora errors should be:
ORA-01653: unable to extend table by 8 in tablespace T1

DB is RAC 10.2.0.3 on Linux 64bit.
Please clarify that for me .
Regards.
Greg
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2010
Added on Mar 5 2010
8 comments
1,021 views