Monday, February 23, 2015

How to solve ORA-02180 when specifying COMPRESSION type

›
You get ORA-02180: invalid option for CREATE TABLESPACE when executing a create tablespace statement like this one: CREATE TABLESPACE test...
Tuesday, February 17, 2015

How cloning from backup became a little more secure in Oracle 11g

›
From version 11, Oracle supplied another method to use during cloning, namely "Backup-based duplication without a target connection...

The emcli utility

›
If you're working in a large Enterprise and are using Cloud Control, you will have access to a neat utility called emcli. emcli is sho...
Friday, January 23, 2015

What is the difference between a BEQUEATH connection and an IPC connection?

›
A bequeath connection runs on your local host bypasses the listener the protocol creates the server process for you directly An IPC (I...
1 comment:
Thursday, January 22, 2015

A complete script for gathering system, data dictionary and fixed objects stats

›
alter session set nls_language='AMERICAN'; set timing on set serveroutput on set lines 200 col pname format a20 BEGIN DBMS_STATS.GA...
Wednesday, January 21, 2015

How to relocate the block change tracking file

›
To relocate the block change tracking file you have two options: 1) shutdown database, mount database, update control file, open database ...
Tuesday, January 20, 2015

Query the registry!

›
To view the different options installed in the database, you should use DBA_REGISTRY, as follows: set lines 200 pages 100 col comp_name f...