Categoria: Oracle Database General

Oracle Database General

maio 29

Como contornar a necessidade de WITH GRANT OPTION em views que acessam tabelas de outros usuários

Há um bom tempo a Oracle introduziu limitações em VIEWS para evitar que algum usuário (com acesso à um determinado objeto no banco de dados) repassasse seu conteúdo para outro, encapsulando-o em views. Como é sempre melhor mostrar exemplos do que escrever teoria, digamos então que temos 3 usuários no banco de dados ( USER_A, …

Continue lendo

maio 10

Dissecting 180417 BP, PSU, RU and RUR

Since Oct-2017 I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. So what oracle internal objects were changed in 180417? VERSION PATCH OWNER TYPE TOTAL -------------------- ---------- ------------------------------ ------------------------------ ---------- 12.1.0.2 BP SYS PACKAGE 1 12.1.0.2 BP SYS …

Continue lendo

maio 08

Oracle 12.2.0.1 JAN2018 RUR - 180417 or 180411 ?

After some delay, Oracle finally released in the end of April the First RUR for 12.2.0.1 Jan-2018 RU. The original release date for this RUR was April 17, 2018 but it was only really available around April 30, 2018. The problem is that because of this delay something get internally messed and instead of using …

Continue lendo

abr 25

New DBMS_ASH and DBMS_BDSQL packages - Apr2018 Patch

After applying the 180417 PSU and BP over 12.1.0.2 Database, I've noted 2 new packages created on the database: DBMS_ASH and DBMS_BDSQL. VERSION PATCH OWNER TYPE NAME -------------------- ---------- -------------------- -------------------- -------------------- 12.1.0.2 PSU & BP SYS PACKAGE DBMS_ASH 12.1.0.2 BP ONLY SYS PACKAGE DBMS_BDSQL 12.1.0.2 BP ONLY SYS PACKAGE BODY DBMS_ASH 12.1.0.2 BP ONLY …

Continue lendo

fev 28

Creating Oracle 18c Database in OCI Classic

In this article, I will show you in details how to create the new released 18c Oracle Database on Oracle Cloud Infrastructure Classic. 1. Creating Trial Account Go to cloud.oracle.com and click on right up corner in "Try for Free". In the new opened page, click on "Create a Free Account". In this page you …

Continue lendo