Development Environment:
Install Oracle XE
on CentOS, check tmpfs in /etc/fstab
none /dev/shm tmpfs defaults,size=2G 0 0
df -h /dev/shm
CONNECT AS SYSDBA
Username: SYSTEM
SELECT
username,
default_tablespace,
profile,
authentication_type
FROM
dba_users
WHERE
account_status = ‚OPEN‘;
SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;
CREATE USER john IDENTIFIED BY passwordhere DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
GRANT CREATE SESSION TO john;
GRANT CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE SEQUENCE TO john