Jacob Asirwadam SK, Biguvu

• May 21st, 2007

 

RAC stands for Real Application Cluster. In previous versions, it is known as PARALLEL SERVER. RAC is a mechanism that allows multiple instances (on different hosts/nodes) to access the same database. The benefits: It provides more memory resources, since more hosts are being used; If one host gets down, then second host assumes it's work load.

Data Pumping is a data movement utility. This is an replacement to imp/exp utilities. imp/exp utilities are also data movement utilities, but they work within the local servers only. Where as, impdp/expdp (Data pumping) are very fast and perform data movements from one database to another database. In other words, it provides secure transports.

When large rows gets updates and no place in extents found to store, then Oracle server searches for the suitable block/extent, if available, it moves entire row from previous one to new block/extent. The process is called Data migration.

If not available, row chained method comes to picture.

senthilora

• Sep 24th, 2007

 

And.. I think, the question is about Data Migration - something related to migrating data between different databases.

I have done using different tools like Data Junction, Informatica, even PL/SQL and SQL Loader.