ORA-01653: unable to extend table

Issue:

[oracle@soauat132 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin/

[oracle@soauat132 bin]$ . oraenv

ORACLE_SID = [oracle] ? soauat

The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app

[oracle@soauat132 bin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 22 09:11:24 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oradata/soauat/system01.dbf

/u01/app/oradata/soauat/sysaux01.dbf

/u01/app/oradata/soauat/undotbs01.dbf

/u01/app/oradata/soauat/users01.dbf

/u01/app/oradata/soauat/example01.dbf

/u01/app/oradata/soauat/DEV_iassdpm.dbf

/u01/app/oradata/soauat/DEV_mds.dbf

/u01/app/oradata/soauat/DEV_soainfra.dbf

/u01/app/oradata/soauat/DEV_orabam.dbf

9 rows selected.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME

------------------------------

SYSTEM

SYSAUX

UNDOTBS1

TEMP

USERS

EXAMPLE

DEV_IAS_ORASDPM

DEV_MDS

DEV_SOAINFRA

DEV_IAS_TEMP

DEV_ORABAM

11 rows selected.

SQL> alter tablespace add datafile'/u01/app/oradata/soauat/DEV_soainfra01.dbf' size 1024m;

alter tablespace add datafile'/u01/app/oradata/soauat/DEV_soainfra01.dbf' size 1024m

                 *

ERROR at line 1:

ORA-02140: invalid tablespace name

SQL> alter tablespace DEV_SOAINFRA add datafile'/u01/app/oradata/soauat/DEV_soainfra01.dbf' size 1024m;

Tablespace altered.

SQL>  select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oradata/soauat/system01.dbf

/u01/app/oradata/soauat/sysaux01.dbf

/u01/app/oradata/soauat/undotbs01.dbf

/u01/app/oradata/soauat/users01.dbf

/u01/app/oradata/soauat/example01.dbf

/u01/app/oradata/soauat/DEV_iassdpm.dbf

/u01/app/oradata/soauat/DEV_mds.dbf

/u01/app/oradata/soauat/DEV_soainfra.dbf

/u01/app/oradata/soauat/DEV_orabam.dbf

/u01/app/oradata/soauat/DEV_soainfra01.dbf

10 rows selected.

SQL>

Now onward  you can deal with tablespace... DEV_SOAINFRA