difference b/w ora-1652 & ora-1653 error????

Hello all,
I recently was attempting to modify the size of some columns of an Oracle 7.1.4
table using the Clarify administration tools, and I received the error:         

"ora-1652 unbable to extend temp segment by 9200 in tablespace CASE."

CASE is not my tablespace for temporary segments. In fact there is only one objec in this tablespace and it is a table.

The error resulted from storage parameters that were too large for the existing space in the tablespace (initial extent 37 meg)...

My qustion is why didn't I receive the ora-1653 error         

"Unable to extend table TABLE.NAME by NUM in tablespace NAME" ???

Does this have something to do with the fact that is was DDL that caused the error and not DML???

What exactly is the diffeence b/w the two errors (1652 & 1653)??

Thanks in advance for any insight!!

Eric Meier
eric.meier_at_cho.ge.com Received on Wed Mar 26 1997 - 00:00:00 CST