SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> create tablespace test datafile '/u01/oracle/oradata/jhknow/test.dbf' size 4m;
Tablespace created.
SQL> create table testtt tablespace test as select * from dba_objects;
create table testtt tablespace test as select * from dba_objects
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEST
SQL> alter database datafile '/u01/oracle/oradata/jhknow/test.dbf' resize 10m;
Database altered.
SQL>create table testtt tablespace test as select * from dba_objects;
Table created.