Hello,
I want to test Oracle OLAP and have come to a problem while installing cube script
I am following this document http://www.oracle.com/technetwork/database/options/olap/global-11g-readme-082667.html
It seems as if some steps were missing in the manual, but strangely I did not manage to find anyone online having the same problem, so it must be me overseeing something.
SQL> @global_11g_create_cubes
This procedure creates the cubes for the sample GLOBAL schema.
You should be logged on as a DBA to execute this procedure.
Specify file system directory containing this installation program.
Example:
c:\download\Global_Schema_11g or /home/oracle/Global_Schema_11g
Directory: /home/oracle/olap
Specify a password for the GLOBAL user.
Enter password:
Connected.
Begin installation
... deleting GLOBAL AW (if it exists)
dbms_cube.import_xml(xmlCLOB);
*
ERROR at line 68:
ORA-06550: line 68, column 7:
PLS-00201: identifier 'DBMS_CUBE.IMPORT_XML' must be declared
ORA-06550: line 68, column 7:
PL/SQL: Statement ignored
Any ideas?