UNix Shell script for Oracle database access through Putty

In Latest R&D for Oracle database which is on Unix plateform. Our Team Member access it through Putty below important script for that

1. go to SqlPlus*

  > sqlplus "/as sysdba"

2) to show all user


> show users

3) to all database
>
4) create tablespace

create tablespace ts_something
  logging
  datafile '/dbf1/ts_sth.dbf' 
  size 32m 
  autoextend on 
  next 32m maxsize 2048m
  extent management local;