CREAR ENTORNO - SQL

CREAR USUARIO

Syntax:
   CREATE USER username
      IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'external_name'}
         options;

options:
  
   DEFAULT TABLESPACE tablespace
   TEMPORARY TABLESPACE tablespace
   QUOTA int {K | M} ON tablespace
   QUOTA UNLIMITED ON tablespace
   PROFILE profile_name
   PASSWORD EXPIRE
   ACCOUNT {LOCK|UNLOCK}

Ejemplo básico:

CREATE USER USU_EXA IDENTIFIED BY USUEXA;

http://ss64.com/ora/user_c.html

DAR PERMISOS AL NUEVO USUARIO

GRANT ALL PRIVILEGES TO USU_EXA
o
GRANT CREATE SESSION,
            CREATE TABLE,
            CREATE VIEW,
            CREATE TRIGGER,
            CREATE SEQUENCE
TO USU_EXA;

Mas información  http://ora.u440.com/usuarios/grant.html


CREAR TABLESPACE

Syntax:
   CREATE [UNDO] TABLESPACE tablespace_name
      DATAFILE Datafile_Options Storage_Options ;

Datafile_Options:
    'filespec' [AUTOEXTEND OFF]
    'filespec' [AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]]

Ejemplo básco:

CREATE TABLESPACE EXA_TBS_TBL
DATAFILE 'C:\oraclexe\oradata\xe\EXA_TBS_TBL.DBF' SIZE 10 M;

CREATE TABLESPACE EXA_TBS_IND
DATAFILE 'C:/oraclexe\oradata\xe\EXA_TBS_IND' SIZE 10M;

http://ss64.com/ora/tablespace_c.html