Extracting ddl for db_links

To extract DDLs for database links in order to identify remote db, user account of the remote db.

SQL> SELECT DBMS_METADATA.GET_DDL('DB_LINK',a.db_link,a.owner)||'/' FROM dba_db_links a;

  CREATE DATABASE LINK "DBLINK1"

   CONNECT TO "REMOTE_DB1" IDENTIFIED BY VALUES '05E67A20C0614597BAB8BB5189C5A5207ED

BE3534CDB2D83F1'

   USING 'SERVICE_NAME1.WORLD'

/

  CREATE DATABASE LINK "DBLINK2"

   CONNECT TO "REMOTE_DB2" IDENTIFIED BY VALUES '05987E6F5E6643D409E175098963854A93C

6A5ED139BD1CA96'

   USING 'SERVICE_NAME2.WORLD'

/

  CREATE DATABASE LINK "DBLINK3"

   CONNECT TO "REMOTE_DB3"  IDENTIFIED BY VALUES '05318971FF97A614216D1EBF0F287777B

6270B7ED5307A6E112C1DEA609B7BF021'

   USING 'SERVICE_NAME3.WORLD'

/

Enabling/Disabling touchpad on HP EliteBook

Several days ago I faced a problem with the non-working touchpad on my HP EliteBook 8470p. It was not too big problem, but sometimes it is more convinient to use the touchpad than mouse. I googled the problem and found several advises. One of them was to reset the notebook by ejecting it's battery and pushing power button in 30 secs. I tried that advice and touchpad became to work, but only before OS loading. As soon as Windows 7 loaded the touchpad goes into disabling with graphical symbol with touchpad crossed by red.
In fact, the problem is resolved on software level with simultaneous double clicking on Fn keyboard and top-left part of the touchpad (with small red light indicator in case of disabled touchpad).

Эффект Даннинга-Крюгера и др.

Эффект Даннинга-Крюгера

«Невежество чаще порождает уверенность, чем знания»

Уверенность - связка знаний, опыта и ... доверия.

"Я подготовил список рассылки и собираюсь его отправить всем через полчаса. Ознакомься с ним и если будут дополнения, предлагаю обсудить"

Test from the office

Test from the office ... It seems the blogspot is open in our proxy today 

SQL Server tips: sp_help... - commands

sp_helpindex 'Customer'
It allows to identify whether the 'Customer' table has any indexes

(Tip from Basic Execution Plans - http://www.youtube.com/watch?v=lvnCRhgfyV0)

sp_helpstats 'Orders'
It shows whether the 'Orders' has a statistics

Don't foget to remove backed up archivelogs!

To avoid stopping of database due to disk space overflow by archivelogs that already backed up by RMAN use:

... delete all input. For instance, 

backup database plus archivelog delete all input;