Flashcards

OPERACIONES SQL

Kathlen Apaza Vera BD2 Spanish 8 cards

Cards in this deck (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

Description: BD2 Flashcards on OPERACIONES SQL, created by Kathlen Apaza Vera on 22/05/2017.
Created by: Kathlen Apaza Vera
Views: 0
Rating