Scott S Nelson

The documentation uses OEM to do this, something that Oracle XE does not have. Has a non-DBA, I find installing Oracle EE tedious. Thanks to waslleysouza.com.br, I was able to find the right script to execute with XE. For the DB-disabled like myself, here are the full steps to do this on a Linux host:

1. login to linux as a member of the dba group or sudo as same
2. # echo $ORACLE_SID
3. # echo $ORACLE_HOME

if either is blank:

# set ORACLE_SID=XE (or your service id)
# set ORACLE_HOME= (Eg: C:oraclexeapporacleproduct10.2.0server)

4. #locate sqlplus
5. run [RESULT FOUND PATH]sqlplus / as sysdba

i.e.,
# /u01/app/oracle/product/11.2.0/xe/bin/sqlplus / as sysdba

6. execute the following (replace values inside [brackets]):

CREATE USER [csuser] IDENTIFIED BY [password] DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GRANT CREATE session, CREATE table, CREATE view TO [csuser];
GRANT UNLIMITED TABLESPACE TO [csuser]; 
COMMIT;

© Scott S. Nelson