Running OLAP Builds to Load Data into Analytical Workspace

Read the document firstly https://docs.oracle.com/cd/E64694_01/CDMIG/E64550-04.pdf This load typically completes in 30-35 minutes. [oracle@PTUD-S07 ~]$ sqlplus ocdm_sample/*********@orcl SQL*Plus: Release 12.1.0.1.0 Production on Thu Dec 3 14:56:25 2015 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Last Successful login time: Thu Dec 03 2015 14:03:22 +07:00 Connected...

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...

Limiting User Privileges when you install sample reports

[oracle@PTUD-S07 ~]$ more a.sql  SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000; select 'CREATE OR REPLACE EDITIONABLE SYNONYM OCDM_REPORT.'||Table_Name||' for OCDM_SYS.'||Table_Name||';' from All_Tables where owner='OCDM_SYS'; [oracle@PTUD-S07 ~]$ sqlplus / as sysdba @a.sql >> b.sql & [4] 141981 [oracle@PTUD-S07 ~]$ cat b.sql | grep 'CREATE OR...