Oracle Tablespace Users

--Create user Mapecun identified by "ACCP";
--alter user username quota unlimited on table space;
--alter User Mapecun quota unlimited on USERS;
--grant create sequence to Mapecun;
/** Grant create session to Mapecun;
Grant CREATE table to Mapecun;
Grant create tablespace to Mapecun;
Grant CREATE view to Mapecun;

Create Tablespace Demospace
DataFile ' e:/oracle_tablespaces/demospace_tbspace.dbf '
Size 150M
Autoextend on next 5M maxsize 300M;

*/

--User rights
--Grant the user permission to use the tablespace:
--alter User Mapecun quota unlimited on demospace;
/**
CREATE TABLE Easybuy_shop
(
ES_ID number is not NULL,
Es_ep_file_name NVARCHAR2 (30),
Es_ep_name NVARCHAR2 (30),
Es_ep_price number,
Es_eod_quantity number,
Es_ep_stock number,
ES_EP_ID number,
es_eu_user_id NVARCHAR2 (30),
Es_valid number
)
Tablespace demospace
Pctfree 10
Initrans 1
Maxtrans 255
Storage
(
Initial 64K
Minextents 1
Maxextents Unlimited
);


ALTER TABLE Easybuy_shop
Add primary key (ES_ID)
Using index
Tablespace demospace
Pctfree 10
Initrans 2
Maxtrans 255
Storage
(
Initial 64K
Minextents 1
Maxextents Unlimited
);

Oracle Tablespace Users