Oracle Database 10g Flashback Technology.

Flashback Database allows the DBA to “roll back” a table, set of tables or the entire database to a previous point-in-time.

First of all change the undo_retention parameter of your database.

SQL>show parameter undo_retention;

# The default value is 900 seconds.

Read more >>

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.

Read more >>

Configuring yum in RHEL5.

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

mkdir -p /var/ftp/pub/repo

Read more >>

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.

Read more >>

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"

Read more >>

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.

Read more >>

Create oracle 10g database manually

It is assumed in this article that you have already installed oracle software.

The purpose of this article is to learn how we can manually create a oracle 10g database without the help of 'DBCA'(Database configuration assistant).

Read more >>