su – oracle

lsnrctl stop
lsnrctl start



sqlplus /nolog
connect /as sysdba
-- shutdown
shutdown immediate
startup

create tablespace kx_fin
   datafile '/home/oracle/oradata/oracle/kx_fin.dbf'
   size 500M
   autoextend on next 100M maxsize unlimited
   extent management local;


create user kx_fin identified by finabc123 default tablespace kx_fin  ;
grant connect,resource to kx_fin;

create user kx_fin_read identified by finabc123  default tablespace kx_fin;
grant connect,resource to kx_fin_read;









ALTER DATABASE DEFAULT TABLESPACE ;




drop user kx_fin cascade;
drop user kx_fin_read cascade;