Search This Blog

Tuesday, August 31, 2010

Oracle 10g Rman Configuration & Backup.

In Oracle database we can do two types of backup’s manual or through
Rman(Recovery Manager).

Then there are two backup modes hot and cold.
Hot backup means, that the backup operations are done when the database
is running.Cold backup is done when the database is shut down or
is in mount stage.

Thursday, August 19, 2010

Configuring yum in RHEL5.

1) Make a directory where all our RHEL5 dvd files will be stored.

mkdir -p /var/ftp/pub/repo

Monday, August 9, 2010

How to hide files and folders in windows xp even when show hidden files and folders option is selected.

Here is a neat trick to hide your folders.

The best thing about this trick is that you can hide your personal data without the help of any third party software.

Sunday, August 8, 2010

Enabling Archive log mode in Oracle 10g and 9i.

First of all make sure that your database is started using spfile.
If you have created your database using DBCA then your database
will automatically start from spfile located in the dbs folder.

path of my spfile is "/u01/app/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora"

Tuesday, August 3, 2010

Creating external tables in oracle 10g.

External Tables lets you query data in a flat file as though the file were an Oracle table. In 10g, you can write out data to an external table, although you cannot write to an existing external table.

While external tables can be queried, they're not usable in many ways regular Oracle tables are. You cannot perform any DML operations on external tables other than table creation. One consequence is that you can't create an index on an external table. External tables are largely used as a convenient way of moving data into and out of the database.