Skip to content

Instantly share code, notes, and snippets.

@diegoolipa
Created March 21, 2025 18:35
Show Gist options
  • Save diegoolipa/7adaddcc3c2ebb26ba8574d4f282a566 to your computer and use it in GitHub Desktop.
Save diegoolipa/7adaddcc3c2ebb26ba8574d4f282a566 to your computer and use it in GitHub Desktop.
Crear una DB EN ORACLE
--CREAR UNA BASE DE DATOS EN ORACLE
--Nombre:dg
--PASO 01
ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
--PASO 02
CREATE USER MATRICULA IDENTIFIED BY "matricula"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
--PASO 03
ALTER USER MATRICULA QUOTA UNLIMITED ON USERS;
--PASO 04
GRANT CREATE SESSION TO MATRICULA;
--PASO 05
GRANT "RESOURCE" TO MATRICULA;
--PASO 06
ALTER USER MATRICULA DEFAULT ROLE "RESOURCE";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment