user-business.sh 333 B

123456
  1. sqlplus sys/oracle as sysdba << EOF
  2. CREATE TABLESPACE business datafile '/u01/app/oracle/oradata/XE/business.dbf' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
  3. create user business identified by business default tablespace business temporary tablespace temp;
  4. grant connect,resource to business;
  5. exit;
  6. EOF