Karteikarten

OPERACIONES SQL

Kathlen Apaza Vera BD2 Spanisch 8 Karten

Karten in diesem Stapel (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

Beschreibung: BD2 Karteikarten am OPERACIONES SQL, erstellt von Kathlen Apaza Vera am 22/05/2017.
Erstellt von: Kathlen Apaza Vera
Aufrufe: 0
Bewertung