Oracle Create and delete accounts

1. Create

/* Step 1th: Create Tablespace */
Create Tablespace Xybi
DataFile ' E:\oracle\oradata\zzxe\xybi_d01 ' size 100M;

/* Step 2nd: Create a temporary tablespace */
Create temporary tablespace xybi_temp
Tempfile ' E:\oracle\oradata\zzxe\xybi_t01 ' size 100M;

/* 3rd step: Create user and specify Tablespace */

Create user Xybi identified by xybi_123
Default Tablespace Xybi
Temporary tablespace xybi_temp;

/* Step 4th: Grant permissions to users */
Grant CONNECT,RESOURCE,DBA to Xybi;

2. Delete Account

Drop user Xybi cascade;

Select Saddr,sid,serial#,paddr,username,status from v$session where username are not null

Alter system kill session ' 133,50 ';

Drop User Xybi Cascade

Oracle Create and delete accounts