Oracle Create Schema

--View Current User select Username from dba_users;--Creating a temporary create USER GZMPC identified by PASSWORD;--authorizing Grant CREATE SESSION to GZMPC; CREATE tablespace gzmoc_wk datafile'Gzmoc_wk.dat'SIZE 10M autoextend on; CREATE temporary tablespace gzmoc_wk_tablespace_temp tempfile'Gzmoc_tabspace_temp.dat'SIZE 5M autoextend on;drop USER gzmpc;--start creating a database Create USER gzmpcidentified by Passworddefault tablespace gzmoc_wktemporary tablespace gzmoc_wk_tablespace_ temp;--authorize grant create session to gzmpc;grant CREATE table to Gzmpc;grant unlimited tablespace to GZMPC;--Finally, modify the password alter USER GZMPC identified by GZMPC;

Oracle Create Schema