tablespace

CREATE tablespace audit_dat
DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\audit_dat.dbf'
size 500m
autoextend on
next 100m
maxsize 1024m;

CREATE tablespace audit_idx
DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\audit_idx.dbf'
size 500m
autoextend on
next 100m
maxsize 1024m;

DROP USER newaudit CASCADE;

CREATE USER newaudit IDENTIFIED BY newaudit
DEFAULT TABLESPACE newaudit_dat
TEMPORARY TABLESPACE temp;

GRANT CREATE SYNONYM TO newaudit;
GRANT RESOURCE TO newaudit;
GRANT CONNECT TO newaudit;