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 to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> begin
pkg_ocdm_olap_etl_aw_load.run;
end;
/
PL/SQL procedure successfully completed.
SQL> select cubename,load_status,error_dtl from dwc_olap_activity order by
cubename;
ACM COMPLETED-SUCCESS
ADM COMPLETED-SUCCESS
AGRMNT COMPLETED-SUCCESS
APM COMPLETED-SUCCESS
CCM COMPLETED-SUCCESS
CHRN COMPLETED-SUCCESS
CMSN COMPLETED-SUCCESS
COM COMPLETED-SUCCESS
CSM COMPLETED-SUCCESS
IAM COMPLETED-SUCCESS
INV COMPLETED-SUCCESS
INVCM COMPLETED-SUCCESS
RVN COMPLETED-SUCCESS
SLS COMPLETED-SUCCESS
14 rows selected.
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 to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> begin
pkg_ocdm_olap_etl_aw_load.run;
end;
/
PL/SQL procedure successfully completed.
SQL> select cubename,load_status,error_dtl from dwc_olap_activity order by
cubename;
ACM COMPLETED-SUCCESS
ADM COMPLETED-SUCCESS
AGRMNT COMPLETED-SUCCESS
APM COMPLETED-SUCCESS
CCM COMPLETED-SUCCESS
CHRN COMPLETED-SUCCESS
CMSN COMPLETED-SUCCESS
COM COMPLETED-SUCCESS
CSM COMPLETED-SUCCESS
IAM COMPLETED-SUCCESS
INV COMPLETED-SUCCESS
INVCM COMPLETED-SUCCESS
RVN COMPLETED-SUCCESS
SLS COMPLETED-SUCCESS
14 rows selected.
0 Comment to "Running OLAP Builds to Load Data into Analytical Workspace"
Post a Comment