Friday, December 21, 2018

How to create a materialized view with query rewrite enabled

›
In this example, I am creating a materialized view to support queries against a table with 20 million rows, which are looking at the maximu...
Thursday, December 20, 2018

How to generate a script to rebuild unusable indexes

›
set trimspool on set lines 200 set pages 0 set heading off set verify off set feedback off set echo off spool re...
Wednesday, December 19, 2018

How to find the version of postgres installed on a server

›
$ su - postgres Last login: Tue Dec 18 23:03:07 CET 2018 $ pg_config --version PostgreSQL 11.1 Using psql: [postgres@til0drift-dbteam-san...
Monday, December 10, 2018

How to send a file to a specific directory using wget

›
Here demonstrated while getting a file from our RH satellite server: wget -P /home/oracle/myfiles http://satellite/oracle/cloningscripts/p...
Friday, December 7, 2018

How to create the SCOTT user

›
To create the user SCOTT, run the script $ORACLE_HOME/rdbms/admin/utlsampl.sql Observe that user SCOTT will be created with the following...
Wednesday, November 28, 2018

Changes in privilege "SELECT ANY DICTIONARY" in Oracle 12c

›
From version 12.1 and onwards, Oracle has introduced some changes to enhance security when granting the system privilege "SELECT ANY D...
Monday, November 19, 2018

How to use rman to create a backup-based clone on a remote server

›
It has been a while since I needed to use this technique, since we rely on storage snapshot clones these days. Sometimes though, a good old...