after_installation_oracle_ubuntu.sh

######  /etc/bash.bashrc 


export JAVA_HOME=/usr/lib/jvm/java-8-oracle
export CLASSPATH=.:$JAVA_HOME/lib
export PATH=$JAVA_HOME/bin:$PATH


export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=$($ORACLE_HOME/bin/nls_lang.sh)
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH


######  source /etc/bash.bashrc 

######  sudo usermod -a -G dba bruno




bruno@ubuntu:~$ sqlplus / as sysdba
SQL> connect / as sysdba
SQL> alter user sys identified by admin;
SQL> alter user system identified by admin;






bruno@ubuntu:~$ sqlplus / as sysdba

SQL> CREATE TABLESPACE ecommerce DATAFILE '/u01/app/oracle/oradata/XE/ecommerce.dbf' SIZE 100m AUTOEXTEND ON NEXT 100m EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

SQL> CREATE USER ecommerce IDENTIFIED BY ecommerce DEFAULT TABLESPACE ecommerce TEMPORARY TABLESPACE temp;

SQL> GRANT CREATE SESSION TO ecommerce;
SQL> GRANT CREATE TABLE TO ecommerce;  
SQL> GRANT CREATE ANY TABLE TO ecommerce;
SQL> ALTER USER ecommerce QUOTA 100M ON ecommerce;
SQL> GRANT UNLIMITED TABLESPACE TO ecommerce;


SQL> GRANT create session, alter session, create table, create procedure, create view, create materialized view, create trigger, create sequence, create any directory, create type, create synonym TO ecommerce;




DROP TABLESPACE ecommerce  INCLUDING CONTENTS    CASCADE CONSTRAINTS; 

select name, open_mode from v$pdbs;




ARCHLINUX


CREATE TABLESPACE test DATAFILE '/usr/lib/oracle/oradata/XE/test.dbf' SIZE 100m AUTOEXTEND ON NEXT 100m EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE USER test IDENTIFIED BY test DEFAULT TABLESPACE test TEMPORARY TABLESPACE temp;

GRANT CREATE SESSION TO test;
GRANT CREATE TABLE TO test;  
GRANT CREATE ANY TABLE TO test;
ALTER USER test QUOTA 100M ON test;
GRANT UNLIMITED TABLESPACE TO test;


GRANT create session, alter session, create table, create procedure, create view, create materialized view, create trigger, create sequence, create any directory, create type, create synonym TO test;