Development Environment:<\/p>\n
Install Oracle XE<\/p>\n
on CentOS, check tmpfs in \/etc\/fstab<\/p>\n
none\u00a0\u00a0\u00a0 \/dev\/shm\u00a0\u00a0\u00a0 tmpfs\u00a0\u00a0\u00a0 defaults,size=2G\u00a0\u00a0\u00a0\u00a0\u00a0 0 0<\/p>\n
df -h \/dev\/shm<\/p>\n
<\/p>\n
CONNECT AS SYSDBA<\/p>\n
Username: SYSTEM<\/p>\n
SELECT
\nusername,
\ndefault_tablespace,
\nprofile,
\nauthentication_type
\nFROM
\ndba_users
\nWHERE
\naccount_status = ‚OPEN‘;<\/p>\n
SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;<\/p>\n
CREATE USER john IDENTIFIED BY passwordhere DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;<\/p>\n
GRANT CREATE SESSION TO john;<\/p>\n
GRANT CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE SEQUENCE TO john<\/p>\n","protected":false},"excerpt":{"rendered":"
Development Environment: Install Oracle XE on CentOS, check tmpfs in \/etc\/fstab none\u00a0\u00a0\u00a0 \/dev\/shm\u00a0\u00a0\u00a0 tmpfs\u00a0\u00a0\u00a0 defaults,size=2G\u00a0\u00a0\u00a0\u00a0\u00a0 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, … Weiterlesen