connect sys/change_on_install as sysdba

CREATE TABLESPACE xml_demod
  LOGGING DATAFILE '/u10/app/oradata/CUSTDB/xml_demod01.dbf' SIZE 10M REUSE
  AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL
/

CREATE TABLESPACE xml_demox
  LOGGING DATAFILE '/u09/app/oradata/CUSTDB/xml_demox01.dbf' SIZE 5M REUSE
  AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL
/

CREATE TABLESPACE xml_docs
  LOGGING DATAFILE '/u10/app/oradata/CUSTDB/xml_docs01.dbf' SIZE 10M REUSE
  AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
  EXTENT MANAGEMENT LOCAL
/

CREATE USER            xml_demo
  IDENTIFIED BY        xml_demo
  DEFAULT TABLESPACE   xml_demod
  TEMPORARY TABLESPACE temp
/

GRANT JAVASYSPRIV, JAVAUSERPRIV, connect, resource, dba TO xml_demo
/


CREATE PUBLIC SYNONYM xmlparser FOR sys.xmlparser
/

GRANT execute ON xmlparser TO PUBLIC;
/

CREATE PUBLIC SYNONYM xmldom FOR sys.xmldom
/

GRANT execute ON xmldom TO PUBLIC
/