Loading the Shell Database for the New User

  1. To check the location of the DPUMP_DIR, enter the following command SELECT * FROM dba_directories;.

    Shell database DMP files are provided with the release and patches in My Oracle Support and are named SHELL_<UnitofMeasure>_<Version>. The options for unit of measure are MET for metric units and IMP for imperial units. An example name for a shell DMP with metric units and version 9.1.X.X is SHELL_MET_910.DMP.

    The source user and source table space are represented in the same file name format but without .DMP. Step 3 shows this in the example.

  2. Copy the selected DMP file into the DPUMP_DIR of the Oracle server.
  3. Open a command prompt with administrative privileges and run the following command:
    impdp system/<password>@<yourinstance> DIRECTORY=DPUMP_DIR DUMPFILE=SHELL_MET_910.DMP PARALLEL=1 LOGFILE=<yourlog>.log REMAP_SCHEMA= SHELL_MET_910:<YOURSCHEMA> REMAP_TABLESPACE=SHELL_MET_910:<YOURTABLESPACE> TRANSFORM=OID:N

    Replace SHELL_MET_910 with the DMP you selected.