Fichas

OPERACIONES SQL

Kathlen Apaza Vera BD2 Español 8 fichas

Fichas del conjunto (8)

1CREAR USUARIOalter session set container = pdborcl;
select open_mode from v$database;
alter database open;
create user oe identified by oe;
2CREAR TABLESPACE
3CREAR TEMPORARY TABLESPACE
4ALGUNOS SELECTselect * from dba_tables;
select * from dba_users;
select * from v$instance;
select * from v$database;
select * from dba_tablespaces;
select * from dba_data_files;
select * from dba_temp_files;
5MODIFICAR TABLESPACEALTER TABLESPACE app_data READ ONLY;
6ELIMINAR TABLESPACEDROP TABLESPACE app_data INCLUDING CONTENTS;
7AUMENTAR TAMAÑO DE TABLESPACEALTER DATABASE
DATAFILE '/DISK5/app_data_02'
RESIZE 200M;
8OBTENER INFO

Descripción: BD2 Fichas sobre OPERACIONES SQL, creado por Kathlen Apaza Vera el 22/05/2017.
Creado por: Kathlen Apaza Vera
Visitas: 0
Valoración