Database Migration Steps from SQL Server 2000 to SQL Server 2005 or 2008
- Nov 20 Wed 2013 18:19
Database Migration Steps from SQL Server 2000 to SQL Server 2005 or 2008
- Nov 11 Mon 2013 10:51
Oracle 11gR2 RAC Installation Procedures on Linux
Oracle 11gR2 RAC (Two-Node) Installation Procedures on RHEL 5.10 (x86-64)
Pre-installation Requirements (Perform on Both Nodes):
- Oct 18 Fri 2013 14:18
Generate HTML Report using SQL*Plus
One thing neat about SQL*Plus is that it can even generate HTML file in addition to text file.
Here's the example:
- Oct 15 Tue 2013 17:16
Using RMAN to Restore A Dropped Tablespace (11gR2)
Using RMAN to Restore A Dropped Tablespace without Resetlogs (11gR2)
##############################################
- Oct 09 Wed 2013 15:10
RMAN Backup Packages
There are two SYS Packages Used by RMAN while performing the backup:
1. SYS.dbms_backup_restore
à used to create system calls to backup datafiles, control files and archived redo logs
- Oct 08 Tue 2013 16:10
Use tar command to archive a directory (with Encryption)
To Archive a Directory to a Encrypted File:
# tar -zcvf - MY_DIR | openssl des3 -salt -k "MY PASSWORD" | dd of=MY_DIR.des3
- Sep 30 Mon 2013 15:21
Simple RMAN Backup and Recovery Example
- Sep 27 Fri 2013 12:21
Oracle 11gR2 Data Guard & Broker Configuration
- Sep 26 Thu 2013 10:50
What are the differences betwen SQL Profile and SPM Baseline?
A very good article explaining the differences between SQL Profile and SPM Baseline :
http://intermediatesql.com/oracle/what-is-the-difference-between-sql-profile-and-spm-baseline/
- Sep 24 Tue 2013 16:59
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Issue:
Dropping a table encountered ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired