--Coisas úteis

-- selecionar os privilégios
select * from session_privs;

-- selecionar materialized views
select mview_name from user_mviews;

-- selecionar links
select * from user_db_links;
select * from all_db_links;

-- criar link entre instâncias de um mesmo servidor
CREATE DATABASE LINK nome_qualquer CONNECT TO nome_de_usuario IDENTIFIED BY senha_do_usuario USING 'itapissuma_dbdisc';

-- criar link de um servidor pra outro
CREATE DATABASE LINK nome_qualquer
CONNECT TO nome_de_usuario IDENTIFIED BY senha_do_usuario
USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=itapissuma.cin.ufpe.br)(PORT=1521)))
(CONNECT_DATA=(SID=dbproj))
)';

--SELECIONAR OS CONSTRAINTS DAS TABELAS DO BD
select constraint_name, r_constraint_name from user_constraints;