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.
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
0 Comment to "How to impdp OCDM_SAMPLE for Oracle Communications Data Model"
Post a Comment