Monthly Archives: dicembre 2016

Oracle:  DBMS_COMPARISON package
  • 14
    Dic

Oracle: DBMS_COMPARISON package

An interesting feature for Oracle 11g is DBMS_COMPARISON package which planned to use compare data within two schemas or between database`s schema. To use DBMS_COMPARISON you have to grant. If you connected as SYSDBA you already have had grant to execute. Other users need execute grants on DBMS_COMPARISON and that user will need to be granted execute catalog...

Read More
Compress table
  • 5
    Dic

Compress table

Scenery: Mass distribution of rich and multimedia content over the Internet, made possible through advancements in broadband technologies, also contributes to the growth in overall data volume. The enormous growth in the volume of data that needs to be retained online makes storage one of the biggest cost elements of most IT budgets. The compression clause can be...

Read More