SYS@bcmspqa1> CREATE TEMPORARY TABLESPACE "APPDEVTEMP" TEMPFILE SIZE 128M
  2  AUTOEXTEND ON NEXT 134217728 MAXSIZE 16G
  3  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
  4  /

Tablespace created.

SYS@bcmspqa1> CREATE TABLESPACE "APPDEV" DATAFILE SIZE 128M
  2  AUTOEXTEND ON NEXT 134217728 MAXSIZE 16G
  3  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  4  EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
  5  NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
  6  /

Tablespace created.

SYS@bcmspqa1> alter user MARVIN_DAVENPORT temporary tablespace appdevtemp default tablespace appdev quota unlimited on appdev;

User altered.

SYS@bcmspqa1> alter user VIJAY_KAPU temporary tablespace appdevtemp default tablespace appdev quota unlimited on appdev;

User altered.

SYS@bcmspqa1> alter user YOGESH_YADAV temporary tablespace appdevtemp default tablespace appdev quota unlimited on appdev;

User altered.

SYS@bcmspqa1> 
SYS@bcmspqa1> revoke unlimited tablespace from MARVIN_DAVENPORT;

Revoke succeeded.

SYS@bcmspqa1> revoke unlimited tablespace from VIJAY_KAPU;

Revoke succeeded.

SYS@bcmspqa1> revoke unlimited tablespace from YOGESH_YADAV;

Revoke succeeded.

SYS@bcmspqa1> 
SYS@bcmspqa1> grant create table to bcmsupdate ;

Grant succeeded.

SYS@bcmspqa1> 
SYS@bcmspqa1> spool off