How to create Tablespace (Tablespace Settings)

http://dbissues.blogspot.com/2016/02/how-to-create-tablespace-tablespace.html

creating tablespace

create tablespace ali datafile '/u01/app/oracle/oradata/ali01' size 5m;

assign tablepsace to user

alter user shafqat default tablespace ali;

For checking tablespace ,and her owner type the command

desc dba_users

select *

  2  from database_properties

  3  where property_name like 'DEFAULT%TABLESPACE';