Difference between utlchain.sql and utlchn1.sql

A very small thought The difference between utlchain.sql and utlchn1.sql is the column head_rowid data type: :::::::::::::: utlchain.sql :::::::::::::: create table CHAINED_ROWS ( owner_name varchar2(30), table_name varchar2(30), cluster_name varchar2(30), partition_name varchar2(30), subpartition_name varchar2(30), head_rowid rowid, analyze_timestamp date ); and :::::::::::::: utlchn1.sql :::::::::::::: create table CHAINED_ROWS ( owner_name varchar2(30), table_name varchar2(30), cluster_name varchar2(30), partition_name varchar2(30), subpartition_name varchar2(30), head_rowid urowid, analyze_timestamp date …

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 …

Installation of Oracle 11g Release 2 (11.2) on RedHat EL 5 and (Oracle) Enteprise Linux 5

Operating System : Linux – (Red Had Enterprise Linux – 5.0) Database Version : Oracle 11g Release 2 (11.2.0) Start a terminal session to server Login as root # login as: root # oracle@127.0.0.1’s password: To determine the distribution and version of Linux installed, enter the following command: # cat /proc/version Or # uname -a Alternatively, you can also enter …

Quick Script to Check Required Packages on Linux

A very quick script to check if the required packages are installed on Linux, I used this one on RHEL 5.5 to check the packages for Oracle Installation rpm -q –qf ‘%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n’ \ binutils control-center gcc gcc-c++ glibc glibc-common \ libstdc++ libstdc++-devel make sysstat libaio \ libaio-devel openmotif21 glibc-devel libgcc \ gdbm libxp libgomp util-linux xorg-x11-libs-compat \ compat-libstdc++ \ …

Oracle 11g Installation on Windows Se7en 64 bit

Lot of users faced similar issues while installation of Oracle 11g on windows 7 64 bit so I thought of posting the setups I used for a successful installation I downloaded the files from OTN with following names: win64_11gR2_database_1of2.zip win64_11gR2_database_2of2.zip Extracted both into the SAME directory with these names C:\Oracle\Disk1 C:\Oracle\Disk2 Started the installation from C:\Oracle\Disk1\database\setup.exe And the Installation failed …