Search This Blog

Sunday, November 27, 2011

SQL*LOADER

This example illustrates how to insert data from a text file to a table in the HR schema using SQL loader.
The data file is named as “records.dat”.
The controlfile file is named as “records.ctl”.
The logfile is named as “records.log”.

1)Connect to the HR schema and create a tables as “TEST”.

Read more >>

Sunday, November 6, 2011

How to repair broken MBR in RHEL 6 ?

1) Go to the grub command line when the system boots up.
2) Find the partition which contains the grub.conf file.
grub> root
  (hd0,0): Filesystem type is unknown, partition type 0x8e
3) Reinstall grub on the returned partition.
grub> setup (hd0)
4) The above command should fix your broken MBR, now reboot the system.
grub> reboot
Read more >>