Hi!
I tried to install the sample schema, can be found here: [http://www.oracle.com/technology/products/bi/olap/11g/samples/schemas/readme.html]
I use windows xp sp3, and oracle enterprise manager version 11.1.0.6. After i downloaded the sample, i tried to install it, first i connected as sysdba with sqlplus, and run the install_olaptrain.sql file with @install_olaptrain. I got no errors, workspace has been created, but the tables hasn't:
This procedure installs the OLAPTRAIN schema for the Oracle OLAP 11g
training class, samples and Oracle by Examples.
1. You should be logged on as a DBA to execute this procedure.
2. Ensure any existing OLAPTRAIN user sessions are disconnected before proceding with the installation (this install will recreate the user if it exists)
Specify file system directory containing this installation program.
Example:
c:\download\olaptrain_install or /home/oracle/olaptrain_install
Directory: f:\app\zz\product\11.1.0\db_1\BIN
Specify a password for the OLAPTRAIN user.
Begin installation
... OLAPTRAIN user exists. Attempting to drop the user.
... creating OLAPTRAIN user
... creating OLAPTRAIN_INSTALL directory
... importing dump file into OLAPTRAIN schema.
... dropping OLAPTRAIN_INSTALL directory
Installation complete.
After that i run the create_olaptrain_cubes.sql file, to see if there the tables were created, and i was the lame to not see them, but i got the following errors:
This procedure creates the cubes for the sample OLAPTRAIN schema.
You should be logged on as a DBA to execute this procedure.
Specify file system directory containing this installation program.
Example:
c:\download\olaptrain_install or /home/oracle/olaptrain_install
Directory: f:\app\zzz\product\11.1.0\db_1\BIN
Specify a password for the OLAPTRAIN user.
Connected.
Begin installation
... deleting SALESTRACK AW (if it exists)
... creating SALESTRACK AW
... importing programs from OLAPTRAIN_INSTALL/all_programs.dml file
... importing cubes from OLAPTRAIN_INSTALL/SALESTRACK_AW file
begin
*
Error at Line 1.:
ORA-37162: OLAP-error
XOQ-00506: Cannot analyze XML-string.
ORA-06512: a(z) "SYS.DBMS_CUBE", at Line 88.
ORA-06512: a(z) "SYS.DBMS_CUBE", at Line 134.
ORA-06512: a(z) "SYS.DBMS_CUBE", at Line 154.
ORA-06512: a(z) "SYS.DBMS_CUBE", at Line 144.
ORA-06512: a(z) "SYS.DBMS_CUBE", at Line 181.
ORA-06512: at Line 2.
I tried manually import the dmp file, can be found in the sample, but i didn't succed. I got many errors:
ORA-39002; invalid operation
ORA-31694: master table "("SYSTEM"."IMPORT000015")" failed to load/unload;
ORA-02354; error in exporting/importing data string
ORA-02373: Error parsing insert statement for table string in "SYSTEM"."IMPORT000015";
ORA-00904: invalid column name "ORIGINAL_OBJECT_NAME":
ORA-39002; invalid operation
ORA-06512: "SYS.DBMS_DATAPUMP", at Line 5067;
ORA-06512: ??? at Line 2.
I hope you can help. Thanks in advance.