Unlock Windows 7 Master Mode

The Windows Master Control Panel shortcut or Windows 7 Master Mode basically lets users access all of the operating system’s control panels from within a single folder like one huge control panel for all the OS settings. This is very simple to unlock, all you have to do is create a folder in a directory of your choice and name …

Requirements for Installing Oracle 11gR2 RDBMS on RHEL Quick Review

This procedure is meant for those planning/trying to install Oracle Server 11.2.0.1.0 (or above) on Red Hat Server 5.2 (or greater) on the 64-bit (x86-64) platform. Since it is the expressed goal to keep Oracle Enterprise Linux functionally IDENTICAL to RHEL, this NOTE is also completely applicable to 64-bit (x86-64) OEL 5.2 or greater. Requirements for Installing 64-bit Oracle 11gR2 …

Recover Objects from Oracle Recyclebin 11g/10g

Using my previous example SQL> select object_name, original_name, type, can_undrop, can_purge, droptime from recyclebin; OBJECT_NAME    ORIGINAL_NAME    TYPE    UND    PUR    DROPTIME ————-    ————–    —-    —-    —    ——— BIN$GI74VOhyTp29f91G/w1VOg==$0    T1    TABLE    YES    YES    2011-02-08:04:23:01 BIN$LPbnFGYmST+6vTnvrdb9WQ==$0    T1    TABLE    YES    YES    2011-02-08:04:22:26 SQL> flashback table t1 to before drop; Flashback complete. SQL> select object_name, original_name, type, can_undrop, can_purge, droptime from recyclebin; OBJECT_NAME    ORIGINAL_NAME    TYPE   …

Use Oracle Recyclebin in 10g/11g

Starting from 10g, The recyclebin is enabled by default and there are two recyclebin views a) USER_RECYCLEBIN and b)DBA_RECYCLEBIN. The synonym RECYCLEBIN points to session USER_RECYCLEBIN. To turn it on or off you need to change the RECYCLEBIN initialization parameter, at the session or system level. When the recyclebin is enabled, any table that you drop is not actually gets …

Turn Off Recyclebin in Oracle 10g/11g

One of the coolest feature in Oracle starting from 10g is recyclebin but sometimes it is annoying to scroll down and see a long list objects dropped, especially in development environment  where you drop more tables than you create. SQL> SHOW PARAMETER RECYCLEBIN NAME                                 TYPE        VALUE ———————————— ———– —————————— recyclebin                           string      on SQL> To turn the feature ON or OFF …