0-Schema.txt

create tablespace inventory
datafile 'inventory.dbf'
size 10M autoextend on;

create temporary tablespace  inventory_tmp
tempfile 'inventory_tmp.dbf' 
size 5M reuse autoextend on ;


create user ouruser	
identified by ourpassword
default tablespace inventory
temporary tablespace inventory_tmp
quota 20M on inventory;


grant create session to ouruser;
grant create table to ouruser;
grant create sequence to ouruser;
grant create trigger to ouruser;
grant create procedure to ouruser;
grant create function to ouruser;
grant create view to ouruser;




http://127.0.0.1:8080/apex/f?p=4950

login as system 

create workspace for ouruser

http://127.0.0.1:8080/apex/f?p=4550

login as ouruser/ourpassword