C:\>sqlplus sys/pwd@xe as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sub Pro 10 10:28:45 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDO
SYSAUX
TEMP
USERS
FLOW_1037931218715706

6 rows selected.

SQL> create user comptech
  2    identified by comp
  3    default tablespace users
  4    quota 10M on users;

User created.

SQL> grant create session,
  2        create table
  3  to comptech;

Grant succeeded.

SQL>

SQL> connect comptech/comp@xe
Connected.
SQL> create table test
  2    (id    number,
  3     ename varchar2(20)
  4    );

Table created.

SQL>