Monthly Archives: febbraio 2014

Create triggers on system events
  • 26
    Feb

Create triggers on system events

System events are particular database states that can be used to fire a system trigger. Is possibile to create triggers for these events at DATABASE or SCHEMA level. When a triggering event occurs, the database will open an autonomous transaction scope, fire the trigger and commit any transaction imbedded in the trigger. The available system events are: AFTER...

Read More
Create Database Link
  • 19
    Feb

Create Database Link

Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services. After you have created a database link,...

Read More
Archive for the ‘DataGuard’ Category
  • 12
    Feb

Archive for the ‘DataGuard’ Category

DATAGUARD:Verifying synchronization between the primary and standby databases By using the following steps, you can control whether the standby database is synchronized with primary: 1. STANDBY DATABASE For the last archived sequence, use the following: SQL> SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG; MAX(SEQUENCE#) ————– 195 For the last applied sequence, use the following: SQL> SELECT MAX(SEQUENCE#) FROM V$ARCHIVED_LOG WHERE APPLIED=’YES’;...

Read More
SQL Server Windows Server 2008 R2 – Tools Command Line
  • 5
    Feb

SQL Server Windows Server 2008 R2 – Tools Command Line

Microsoft makes provisions of the tools to perform operations at the command line. The most famous are Robocopy.exe (copy / sync files and folders), Calcs.exe (management of permissions on files and folders), Dnscmd.exe (add / remove DNS records), etc. .. Unlike previous versions, if you need to use these tools on Windows Server 2008 R2 it is not...

Read More