IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: December 2009

Using Transportable Tablespace in Oracle Database 10g

2 Comments Posted by on December 22, 2009

Introduction: Oracle’s transportable tablespace feature allows users to quickly move a user tablespace across Oracle databases.  It is the most efficient way to move bulk data between databases. Moving data using transportable tablespaces can be much faster than performing either an export/import or unload/load of the same data. This is because transporting a tablespace only requires [...]

Oracle Database 10g , , , ,

Oracle Data Pump Technology – Oracle Database 10g

3 Comments Posted by on December 19, 2009

Introduction: Oracle datapump technology refers to the new import and export functionality introduced in Oracle database 10g. New import/export technology is far superior then the traditional import/export tools available until Oracle database 9i. Data pump manages multiple, parallel stream of data to achieve maximum throughput. Oracle claims that Data Pump allows you to decrease the [...]

Oracle Database 10g , , , , ,

Manual Cleanup of CRS installation – Oracle CRS 10g R2 (10.2.0.1)

4 Comments Posted by on December 17, 2009

Some times we have to do a maual cleanup of failed CRS installation or some old CRS installation that was done. We have a automated way of cleaning up CRS as show below 1) Run rootdelete.sh script present in $ORA_CRS_HOME/install directory 2) Run rootdeinstall.sh script present in $ORA_CRS_HOME/install directory If you have unknowingly deleted the [...]

Oracle Database 10g , ,

Follow

Get every new post delivered to your Inbox.

Join 130 other followers