menu

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Datapump expdp/impdp utility

Datapump expdp/impdp utility.

Oracle gave two utilities like (exp and imp) and (expdp and impdp) to transport database. After 10g the traditional exp/imp become obsolete and additional method like expdp and impdp was introduced.

Datapump Export (expdp/ impdp)


This is also an ORACLE database external utility,that is used to transfer objects between databases. This utility is started from ORACLE 10g database. This utility also makes dump files of binary formats with database objects, object metadata and their control information. The expdp and impdp commands can be executed in the three ways followed:

How to start Oracle 10g/11g Report Server

Oracle 10g Report Server Configuration: (Windows 7,8.1,10)


  1. Go to  c:\DevSuiteHome_1\reports\conf\rwservlet.properties
  2. Remove the # Comment and add Server=myrpserv
  3. Now go to the Command Prompt. e.g. Run> cmd
  4. Now set the home: 
    1. set ORACLE_HOME=c:\DevSuiteHome_1
    2. PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jlib;%ORACLE_HOME%\jdk\bin
  5. Now run the server from CMD. 
    1. C:\DEVSUITEHOME_1\BIN\rwserver server=myrpserv autostart=yes

Oracle 11g Start Oracle Report Server :


Step -1:

How to auto start oc4j from service.

Running Oc4j in Oracle 10g Developer Suite every time is very much irritating for the developers. That's why I am going to solve the problem. I want to run the OC4j from service. When the windows starts the oc4j will automatically starts and will not show any black screen. For that we have to follow the steps described below:

  1. Download and unziphttp://nssm.cc/release/nssm-2.24.zip
  2. Extract the zip file to the D drive (suppose).
  3. Now go to Run>CMD