How to impdp OCDM_SAMPLE for Oracle Communications Data Model

Step 1: Create tablespace for OCDM_SAMPLE:

SQL>  create tablespace DW_OCDM_SAMPLE datafile '/u01/app/oracle/admin/orcl/datafile/DW_OCDM_SAMPLE.dbf' size 100M autoextend on next 10M;
Tablespace created.
SQL>  create temporary tablespace DW_OCDM_SAMPLE_TEMP tempfile '/u01/app/oracle/admin/orcl/datafile/DW_OCDM_SAMPLE_TEMP.dbf' size 100M autoextend on next 10M;
Tablespace created.

Step 2: Create user ocdm_sample and grant privilege for the user.

create user "OCDM_SAMPLE" identified by ********** profile "DEFAULT" account unlock default tablespace  "DW_OCDM_SAMPLE" temporary tablespace "DW_OCDM_SAMPLE_TEMP";
     
grant CREATE SESSION to "OCDM_SAMPLE";
grant CREATE TYPE to "OCDM_SAMPLE";
grant CREATE SYNONYM to "OCDM_SAMPLE";
grant CREATE MATERIALIZED VIEW to "OCDM_SAMPLE";
grant CREATE TABLE to "OCDM_SAMPLE";
grant CREATE DIMENSION to "OCDM_SAMPLE";
grant CREATE SEQUENCE to "OCDM_SAMPLE";
grant CREATE VIEW to "OCDM_SAMPLE";
grant CREATE JOB to "OCDM_SAMPLE";
grant "OLAP_USER" to "OCDM_SAMPLE";
grant CREATE PROCEDURE to "OCDM_SAMPLE";
grant CREATE TABLESPACE to "OCDM_SAMPLE";
grant CREATE MINING MODEL to "OCDM_SAMPLE";
grant UNLIMITED TABLESPACE to "OCDM_SAMPLE";

Step 3: Import ocdm_sample.dmp

impdp system/******* directory=dump_dir dumpfile=ocdm_sample.dmp logfile=ocdm_sample.log

Tweet