参考文档：MOS Doc ID 472408.1
基于 AMERICAN_AMERICA.US7ASCII 字符集
[oracle@orcl1 schema]$ cd /u01/app/oracle/product/11.2.0/db_1/demo/schema/
[oracle@orcl1 schema]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 25 15:54:50 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @mkplug.sql
specify password for SYS as parameter 1:
Enter value for 1: oracle
specify password for HR as parameter 2:
Enter value for 2: oracle
specify password for OE as parameter 3:
Enter value for 3: oracle
specify password for PM as parameter 4:
Enter value for 4: oracle
specify password for IX as parameter 5:
Enter value for 5: oracle
specify password for SH as parameter 6:
Enter value for 6: oracle
specify password for BI as parameter 7:
Enter value for 7: oracle
specify INPUT metadata import file as parameter 8:
Enter value for 8: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example.dmp
specify INPUT database backup file for tablespace EXAMPLE as parameter 9:
Enter value for 9: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example01.dfb
specify OUTPUT database file for tablespace EXAMPLE as parameter 10:
Enter value for 10: /oradata/ORCL/example01.dbf
specify OUTPUT log directory as parameter 11:
Enter value for 11: /home/oracle/log.txt
specify OUTPUT dump file directory as parameter 12:
Enter value for 12: /home/oracle/
Sample Schemas are being plugged in ...
Connected.
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:07
1 row selected.
old 1: CREATE USER hr IDENTIFIED BY &&password_hr
new 1: CREATE USER hr IDENTIFIED BY oracle
User created.
old 1: CREATE USER oe IDENTIFIED BY &&password_oe
new 1: CREATE USER oe IDENTIFIED BY oracle
User created.
old 1: CREATE USER ix IDENTIFIED BY &&password_ix
new 1: CREATE USER ix IDENTIFIED BY oracle
User created.
old 1: CREATE USER sh IDENTIFIED BY &&password_sh
new 1: CREATE USER sh IDENTIFIED BY oracle
User created.
old 1: CREATE USER pm IDENTIFIED BY &&password_pm
new 1: CREATE USER pm IDENTIFIED BY oracle
User created.
old 1: CREATE USER bi IDENTIFIED BY &&password_bi
new 1: CREATE USER bi IDENTIFIED BY oracle
User created.
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> CREATE OR REPLACE DIRECTORY data_file_dir AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/';
Directory created.
SQL> CREATE OR REPLACE DIRECTORY log_file_dir AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/log/';
Directory created.
SQL> CREATE OR REPLACE DIRECTORY media_dir AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/';
Directory created.
SQL>
SQL> GRANT READ ON DIRECTORY media_dir TO pm;
Grant succeeded.
SQL> GRANT READ ON DIRECTORY log_file_dir TO sh;
Grant succeeded.
SQL> GRANT READ ON DIRECTORY data_file_dir TO sh;
Grant succeeded.
SQL> GRANT WRITE ON DIRECTORY log_file_dir TO sh;
Grant succeeded.
SQL> EXECUTE DBMS_DATAPUMP_UTL.REPLACE_DEFAULT_DIR;
PL/SQL procedure successfully completed.
SQL> EXECUTE ORACLE_OCM.MGMT_CONFIG_UTL.create_replace_dir_obj;
PL/SQL procedure successfully completed.
SQL>
SQL> GRANT CREATE SESSION TO hr;
Grant succeeded.
SQL> GRANT ALTER SESSION TO hr;
Grant succeeded.
SQL> GRANT CREATE DATABASE LINK TO hr;
Grant succeeded.
SQL> GRANT CREATE SEQUENCE TO hr;
Grant succeeded.
SQL> GRANT CREATE SYNONYM TO hr;
Grant succeeded.
SQL> GRANT CREATE VIEW TO hr;
Grant succeeded.
SQL> GRANT RESOURCE TO hr;
Grant succeeded.
SQL> GRANT execute ON sys.dbms_stats TO hr;
Grant succeeded.
SQL>
SQL> GRANT CREATE SESSION TO oe;
Grant succeeded.
SQL> GRANT CREATE DATABASE LINK TO oe;
Grant succeeded.
SQL> GRANT CREATE SYNONYM TO oe;
Grant succeeded.
SQL> GRANT CREATE VIEW TO oe;
Grant succeeded.
SQL> GRANT RESOURCE TO oe;
Grant succeeded.
SQL> GRANT CREATE MATERIALIZED VIEW TO oe;
Grant succeeded.
SQL> GRANT QUERY REWRITE TO oe;
Grant succeeded.
SQL> GRANT execute ON sys.dbms_stats TO oe;
Grant succeeded.
SQL>
SQL> GRANT CONNECT TO pm;
Grant succeeded.
SQL> GRANT RESOURCE TO pm;
Grant succeeded.
SQL> GRANT execute ON sys.dbms_stats TO pm;
Grant succeeded.
SQL> GRANT READ ON DIRECTORY media_dir TO pm;
Grant succeeded.
SQL>
SQL> GRANT CONNECT TO ix;
Grant succeeded.
SQL> GRANT RESOURCE TO ix;
Grant succeeded.
SQL>
SQL> GRANT aq_administrator_role TO ix;
Grant succeeded.
SQL> GRANT aq_user_role TO ix;
Grant succeeded.
SQL>
SQL> GRANT ALTER SESSION TO ix;
Grant succeeded.
SQL> GRANT CREATE CLUSTER TO ix;
Grant succeeded.
SQL> GRANT CREATE DATABASE LINK TO ix;
Grant succeeded.
SQL> GRANT CREATE SEQUENCE TO ix;
Grant succeeded.
SQL> GRANT CREATE SESSION TO ix;
Grant succeeded.
SQL> GRANT CREATE SYNONYM TO ix;
Grant succeeded.
SQL> GRANT CREATE TABLE TO ix;
Grant succeeded.
SQL> GRANT CREATE VIEW TO ix;
Grant succeeded.
SQL> GRANT CREATE CLUSTER TO ix;
Grant succeeded.
SQL> GRANT CREATE INDEXTYPE TO ix;
Grant succeeded.
SQL> GRANT CREATE OPERATOR TO ix;
Grant succeeded.
SQL> GRANT CREATE PROCEDURE TO ix;
Grant succeeded.
SQL> GRANT CREATE SEQUENCE TO ix;
Grant succeeded.
SQL> GRANT CREATE TABLE TO ix;
Grant succeeded.
SQL> GRANT CREATE TRIGGER TO ix;
Grant succeeded.
SQL> GRANT CREATE TYPE TO ix;
Grant succeeded.
SQL> GRANT CREATE SESSION TO ix;
Grant succeeded.
SQL>
SQL> GRANT CONNECT, RESOURCE, SELECT_CATALOG_ROLE TO ix;
Grant succeeded.
SQL>
SQL> GRANT EXECUTE ON sys.dbms_stats TO ix;
Grant succeeded.
SQL> GRANT EXECUTE ON DBMS_AQ TO ix;
Grant succeeded.
SQL> GRANT EXECUTE ON DBMS_AQADM TO ix;
Grant succeeded.
SQL> GRANT EXECUTE ON DBMS_APPLY_ADM TO ix;
Grant succeeded.
SQL> GRANT EXECUTE ON DBMS_CAPTURE_ADM TO ix;
Grant succeeded.
SQL> GRANT EXECUTE ON DBMS_FLASHBACK TO ix;
Grant succeeded.
SQL> GRANT EXECUTE ON DBMS_PROPAGATION_ADM TO ix;
Grant succeeded.
SQL> GRANT EXECUTE ON DBMS_STREAMS_ADM TO ix;
Grant succeeded.
SQL> GRANT SELECT ANY DICTIONARY TO ix;
Grant succeeded.
SQL>
SQL> EXECUTE DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( -
> privilege => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, -
> grantee => 'ix', -
> grant_option => FALSE);
PL/SQL procedure successfully completed.
SQL>
SQL> EXECUTE DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( -
> privilege => DBMS_RULE_ADM.CREATE_RULE_OBJ, -
> grantee => 'ix', -
> grant_option => FALSE);
PL/SQL procedure successfully completed.
SQL>
SQL> GRANT CREATE SESSION TO sh;
Grant succeeded.
SQL> GRANT CREATE TABLE TO sh;
Grant succeeded.
SQL> GRANT CREATE VIEW TO sh;
Grant succeeded.
SQL> GRANT CREATE CLUSTER TO sh;
Grant succeeded.
SQL> GRANT ALTER SESSION TO sh;
Grant succeeded.
SQL> GRANT CREATE SEQUENCE TO sh;
Grant succeeded.
SQL> GRANT CREATE SYNONYM TO sh;
Grant succeeded.
SQL> GRANT CREATE DATABASE LINK TO sh;
Grant succeeded.
SQL> GRANT CREATE DIMENSION TO sh;
Grant succeeded.
SQL> GRANT QUERY REWRITE TO sh;
Grant succeeded.
SQL> GRANT CREATE MATERIALIZED VIEW TO sh;
Grant succeeded.
SQL> GRANT CREATE VIEW TO sh;
Grant succeeded.
SQL> GRANT RESOURCE TO sh;
Grant succeeded.
SQL> GRANT select_catalog_role TO sh;
Grant succeeded.
SQL> GRANT cwm_user TO sh;
Grant succeeded.
SQL> GRANT execute ON sys.dbms_stats TO sh;
Grant succeeded.
SQL> rem ALTER USER sh GRANT CONNECT THROUGH olapsvr;
SQL>
SQL> GRANT CREATE SESSION TO bi;
Grant succeeded.
SQL> GRANT CREATE TABLE TO bi;
Grant succeeded.
SQL> GRANT CREATE VIEW TO bi;
Grant succeeded.
SQL> GRANT CREATE CLUSTER TO bi;
Grant succeeded.
SQL> GRANT ALTER SESSION TO bi;
Grant succeeded.
SQL> GRANT CREATE SEQUENCE TO bi;
Grant succeeded.
SQL> GRANT CREATE SYNONYM TO bi;
Grant succeeded.
SQL> GRANT CREATE DATABASE LINK TO bi;
Grant succeeded.
SQL> GRANT RESOURCE TO bi;
Grant succeeded.
SQL>
SQL> --
SQL> -- Restoring database file backup
SQL> -- (Using RMAN works in OMF, OCFS, raw devices and in normal file systems)
SQL> --
SQL>
SQL>
SQL> set echo off;
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:07
1 row selected.
old 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'&data_file_name');
new 30: dbms_backup_restore.restoreDataFileTo(data_file_id,'/oradata/ORCL/example01.dbf');
old 33: dbms_backup_restore.restoreBackupPiece('&dump_path'||'&data_file_backup', done);
new 33: dbms_backup_restore.restoreBackupPiece('/home/oracle/'||'/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example01.dfb', done);
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
declare
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece
/home/oracle/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/exampl
e01.dfb
ORA-19505: failed to identify file
"/home/oracle/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/examp
le01.dfb"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 5937
ORA-06512: at line 33
1 row selected.
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:07
1 row selected.
old 1: create or replace directory SS_IMPEXP_DIR as '&dump_path'
new 1: create or replace directory SS_IMPEXP_DIR as '/home/oracle/'
Directory created.
Grant succeeded.
old 1: create or replace directory SS_LOGPATH_DIR as '&log_path'
new 1: create or replace directory SS_LOGPATH_DIR as '/home/oracle/log.txt'
Directory created.
Grant succeeded.
LRM-00118: syntax error at '=' at the end of input
Connected.
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08
1 row selected.
ALTER TABLESPACE example READ WRITE
*
ERROR at line 1:
ORA-00959: tablespace 'EXAMPLE' does not exist
TABLESPACE_NAME FILE_NAME STATUS
--------------- ---------------------------------------------- ---------
SYSTEM /oradata/ORCL/system01.dbf AVAILABLE
SYSAUX /oradata/ORCL/sysaux01.dbf AVAILABLE
UNDOTBS1 /oradata/ORCL/undotbs01.dbf AVAILABLE
USERS /oradata/ORCL/user01.dbf AVAILABLE
4 rows selected.
Creating sequences, views, procedures and objects privileges for HR ...
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08
1 row selected.
Connected.
Sequence created.
Sequence created.
Sequence created.
regions r
*
ERROR at line 41:
ORA-00942: table or view does not exist
Procedure created.
BEFORE INSERT OR UPDATE OR DELETE ON employees
*
ERROR at line 2:
ORA-00942: table or view does not exist
ALTER TRIGGER secure_employees DISABLE
*
ERROR at line 1:
ORA-04080: trigger 'SECURE_EMPLOYEES' does not exist
Warning: Procedure created with compilation errors.
AFTER UPDATE OF job_id, department_id ON employees
*
ERROR at line 2:
ORA-00942: table or view does not exist
Commit complete.
GRANT REFERENCES, SELECT ON employees TO oe
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT REFERENCES, SELECT ON countries TO oe
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT REFERENCES, SELECT ON locations TO oe
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON jobs TO oe
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON job_history TO oe
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON departments TO oe
*
ERROR at line 1:
ORA-00942: table or view does not exist
Creating synonyms, sequences, views and functions for OE ...
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08
1 row selected.
Connected.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Sequence created.
, product_descriptions d
*
ERROR at line 22:
ORA-00942: table or view does not exist
, products p
*
ERROR at line 8:
ORA-00942: table or view does not exist
, products p
*
ERROR at line 8:
ORA-00942: table or view does not exist
, products p
*
ERROR at line 8:
ORA-00942: table or view does not exist
FROM product_information
*
ERROR at line 7:
ORA-00942: table or view does not exist
FROM customers c, countries cr
*
ERROR at line 7:
ORA-00980: synonym translation is no longer valid
Warning: Function created with compilation errors.
customers c
*
ERROR at line 30:
ORA-00942: table or view does not exist
FROM orders
*
ERROR at line 11:
ORA-00942: table or view does not exist
Creating XML schema, XML folders, OC subschema and objects privileges for OE ...
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08
1 row selected.
specify password for OE as parameter 1:
PROMPT password for SYS as parameter 2:
Connected.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
1* GRANT alter session TO oe
Grant succeeded.
View created.
View created.
Grant succeeded.
Session altered.
Package created.
Warning: Package Body created with compilation errors.
View created.
Package altered.
View altered.
Grant succeeded.
Trigger created.
Synonym created.
Grant succeeded.
Call completed.
Session altered.
Session altered.
Function created.
no rows selected
Synonym created.
Grant succeeded.
Package created.
no rows selected
Synonym created.
Grant succeeded.
Package created.
no rows selected
Package body created.
no rows selected
Synonym created.
Grant succeeded.
Package created.
no rows selected
Package body created.
no rows selected
Grant succeeded.
Synonym created.
Package created.
no rows selected
Package body created.
no rows selected
Synonym created.
Grant succeeded.
PL/SQL procedure successfully completed.
Connected.
DROP DIRECTORY SS_OE_XMLDIR
*
ERROR at line 1:
ORA-04043: object SS_OE_XMLDIR does not exist
Directory created.
Commit complete.
Connected.
Revoke succeeded.
Connected.
Connected.
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Call completed.
Call completed.
PL/SQL procedure successfully completed.
Connected.
Revoke succeeded.
Connected.
Connected.
Revoke succeeded.
Revoke succeeded.
Revoke succeeded.
Package dropped.
Package dropped.
Package dropped.
Package dropped.
Package dropped.
Trigger dropped.
View dropped.
Connected.
Session altered.
...creating subschema OC in OE
Type created.
Type created.
Type created.
Type created.
Type created.
Type created.
Type created.
Type created.
Type created.
Warning: Type created with compilation errors.
Type created.
Type created.
Type created.
Warning: Type created with compilation errors.
Type created.
Type body created.
Type created.
Type body created.
Type created.
Type body created.
Table created.
FROM inventories i, warehouses w
*
ERROR at line 6:
ORA-00942: table or view does not exist
FROM product_information p
*
ERROR at line 10:
ORA-00942: table or view does not exist
FROM customers c
*
ERROR at line 20:
ORA-00942: table or view does not exist
FROM customers c
*
ERROR at line 20:
ORA-00942: table or view does not exist
FROM customers c
*
ERROR at line 20:
ORA-00942: table or view does not exist
FROM orders o
*
ERROR at line 9:
ORA-00942: table or view does not exist
ON oc_orders FOR EACH ROW
*
ERROR at line 2:
ORA-00942: table or view does not exist
TABLE order_item_list OF oc_orders FOR EACH ROW
*
ERROR at line 2:
ORA-00942: table or view does not exist
Commit complete.
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 5:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 5:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 5:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 5:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
FROM oc_product_information o
*
ERROR at line 4:
ORA-00942: table or view does not exist
1 row created.
1 row created.
1 row created.
1 row created.
Type altered.
3 rows updated.
0 rows updated.
0 rows updated.
0 rows updated.
Commit complete.
Type body altered.
Type body altered.
Type body altered.
GRANT SELECT ON bombay_inventory TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON customers TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON inventories TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON orders TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON order_items TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON products TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON product_descriptions TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON product_information TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON product_prices TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON promotions TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON sydney_inventory TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON toronto_inventory TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON warehouses TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT REFERENCES, SELECT ON product_information TO pm
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON order_items TO pm
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON orders TO pm
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON product_descriptions TO pm
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON inventories TO pm
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON customers TO pm
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON warehouses TO pm
*
ERROR at line 1:
ORA-00942: table or view does not exist
Creating dimensions, materialized views, external table and object privileges for SH ...
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:14
1 row selected.
Connected.
CREATE DIMENSION customers_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist
Commit complete.
BEGIN dbms_olap.validate_dimension('customers_dim','sh',false,true); END;
*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1
no rows selected
CREATE DIMENSION products_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist
BEGIN dbms_olap.validate_dimension('products_dim','sh',false,true); END;
*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1
no rows selected
CREATE DIMENSION times_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist
BEGIN dbms_olap.validate_dimension('times_dim','sh',false,true); END;
*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1
no rows selected
CREATE DIMENSION channels_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist
BEGIN dbms_olap.validate_dimension('channels_dim','sh',false,true); END;
*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1
no rows selected
CREATE DIMENSION promotions_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist
BEGIN dbms_olap.validate_dimension('promotions_dim','sh',false,true); END;
*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1
no rows selected
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:14
1 row selected.
FROM costs c, sales s
*
ERROR at line 13:
ORA-00942: table or view does not exist
, times t
*
ERROR at line 8:
ORA-00942: table or view does not exist
, products p
*
ERROR at line 12:
ORA-00942: table or view does not exist
Table created.
Creating OLAP metadata ...
<<<<< CREATE CWMLite Metadata for the Sales History Schema >>>>>
-
<<<<< CREATE CATALOG sh_cat for Sales History >>>>>
No catalog to drop
CWM Collect Garbage
-
<<<<< CREATE the Sales CUBE >>>>>
Sales amount, Sales quantity
<TIMES CHANNELS PRODUCTS CUSTOMERS PROMOTIONS >
Drop SALES_CUBE prior to recreation
No cube to drop
Add dimensions -
to SALES_CUBE and map the foreign keys
ERROR:: dimension_not_found
Object Type: DIMENSION
Object Owner: SH
Object Name: TIMES_DIM
Secondary Name:
Tertiary Name:
User-Defined Exception
ERROR: dimension_not_found
declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM$OLAP$DIMENSION", line 242
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM$UTIL", line 368
ORA-01403: no data found
ORA-06512: at line 1691
Commit complete.
GRANT SELECT ON channels TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON countries TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON times TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON costs TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON customers TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON products TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON promotions TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON sales TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON times TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON cal_month_sales_mv TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
GRANT SELECT ON sh.fweek_pscat_sales_mv TO bi
*
ERROR at line 1:
ORA-00942: table or view does not exist
Creating views, synonyms for BI ...
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:15
1 row selected.
specify password for BI as parameter 1:
Connected.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Synonym created.
Commit complete.
Connected.
PL/SQL procedure successfully completed.
Connected.
BEGIN dbms_aqadm_sys.validate_Queue('IX', 'AQ$_ORDERS_QUEUETABLE_E'); END;
*
ERROR at line 1:
ORA-24010: QUEUE IX.AQ$_ORDERS_QUEUETABLE_E does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1
BEGIN dbms_aqadm_sys.validate_Queue('IX', 'AQ$_STREAMS_QUEUE_TABLE_E'); END;
*
ERROR at line 1:
ORA-24010: QUEUE IX.AQ$_STREAMS_QUEUE_TABLE_E does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1
BEGIN dbms_aqadm_sys.validate_Queue('IX', 'ORDERS_QUEUE'); END;
*
ERROR at line 1:
ORA-24010: QUEUE IX.ORDERS_QUEUE does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1
BEGIN dbms_aqadm_sys.validate_Queue('IX', 'STREAMS_QUEUE'); END;
*
ERROR at line 1:
ORA-24010: QUEUE IX.STREAMS_QUEUE does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1
Directory dropped.
Directory dropped.
mkplug.sql DONE
TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:16
1 row selected.
SQL>