oracle operations on sessions, users and tablespaces

select SID,SERIAL# from v$session where username like 'RICKDEV';

alter system kill session ;

drop user devrick cascade;

create user devrick identified by devrick;

grant all privileges to devrick;

grant dba to devrick;

drop tablespace TBSTI_DRGMGR_SYSTEM_DATA INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

drop tablespace TBSTI_DRGMGR_SYSTEM_INDEX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

CREATE TABLESPACE TBSTI_DRGMGR_SYSTEM_DATA DATAFILE '/DRGMGR10/TBSTI_DRGMGR_SYSTEM_dataRick.dbf' SIZE 5M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT DEFAULT NOCOMPRESS EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE TBSTI_DRGMGR_SYSTEM_INDEX DATAFILE '/DRGMGR10/TBSTI_DRGMGR_SYSTEM_indexRick.dbf' SIZE 5M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT DEFAULT NOCOMPRESS EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

ALTER USER devrick QUOTA UNLIMITED ON TBSTI_DRGMGR_SYSTEM_DATA;

ALTER USER devrick QUOTA UNLIMITED ON TBSTI_DRGMGR_SYSTEM_INDEX;