

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section4 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
export ORACLE_SID=PROD
.bash_profile OK



# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/jdk/bin:$ORACLE_HOME/bin:$PATH
export LANG=en_US


******************** TOPIC 1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
CAL_MONTH_SALES_MV	       SELECT	t.calendar_month_desc
				 ,	  sum(s.amount_sold) AS dollars
				 FROM	  sales s
				 ,	  times t
				 WHERE	  s.time_id = t.time_id
				 GROUP BY t.calendar_month_desc

FWEEK_PSCAT_SALES_MV	       SELECT	t.week_ending_day
				 ,	  p.prod_subcategory
				 ,	  sum(s.amount_sold) AS dollars
				 ,	  s.channel_id

MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
				 ,	  s.promo_id
				 FROM	  sales s
				 ,	  times t
				 ,	  products p
				 WHERE	  s.time_id = t.time_id
				 AND	  s.prod_id = p.prod_id
				 GROUP BY t.week_ending_day
				 ,	  p.prod_subcategory
				 ,	  s.channel_id
				 ,	  s.promo_id


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
CAL_MONTH_SALES_MV	       SELECT	t.calendar_month_desc
				 ,	  sum(s.amount_sold) AS dollars
				 FROM	  sales s
				 ,	  times t
				 WHERE	  s.time_id = t.time_id
				 GROUP BY t.calendar_month_desc

FWEEK_PSCAT_SALES_MV	       SELECT	t.week_ending_day
				 ,	  p.prod_subcategory
				 ,	  sum(s.amount_sold) AS dollars
				 ,	  s.channel_id

MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
				 ,	  s.promo_id
				 FROM	  sales s
				 ,	  times t
				 ,	  products p
				 WHERE	  s.time_id = t.time_id
				 AND	  s.prod_id = p.prod_id
				 GROUP BY t.week_ending_day
				 ,	  p.prod_subcategory
				 ,	  s.channel_id
				 ,	  s.promo_id


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
CAL_MONTH_SALES_MV	       SELECT	t.calendar_month_desc
				 ,	  sum(s.amount_sold) AS dollars
				 FROM	  sales s
				 ,	  times t
				 WHERE	  s.time_id = t.time_id
				 GROUP BY t.calendar_month_desc

FWEEK_PSCAT_SALES_MV	       SELECT	t.week_ending_day
				 ,	  p.prod_subcategory
				 ,	  sum(s.amount_sold) AS dollars
				 ,	  s.channel_id

MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
				 ,	  s.promo_id
				 FROM	  sales s
				 ,	  times t
				 ,	  products p
				 WHERE	  s.time_id = t.time_id
				 AND	  s.prod_id = p.prod_id
				 GROUP BY t.week_ending_day
				 ,	  p.prod_subcategory
				 ,	  s.channel_id
				 ,	  s.promo_id


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 0


R101003=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:55 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
1 row created.

SQL> 
Commit complete.

SQL> BEGIN dbms_mview.refresh('SH.PROD_MV','F'); END;

*
ERROR at line 1:
ORA-23401: materialized view "SH"."PROD_MV" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101004=0


A: ERROR at line 1:

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:56 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
1 row deleted.

SQL> 
Commit complete.

SQL> BEGIN dbms_mview.refresh('SH.PROD_MV','F'); END;

*
ERROR at line 1:
ORA-23401: materialized view "SH"."PROD_MV" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101005=0


A: ERROR at line 1:

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:56 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
1 row updated.

SQL> 
Commit complete.

SQL> BEGIN dbms_mview.refresh('SH.PROD_MV','F'); END;

*
ERROR at line 1:
ORA-23401: materialized view "SH"."PROD_MV" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101006=0


A: ERROR at line 1:

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:56 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> drop TABLE MV_CAPABILITIES_TABLE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> 
Table created.

SQL> BEGIN dbms_mview.explain_mview(mv => 'SH.PROD_MV'); END;

*
ERROR at line 1:
ORA-23401: materialized view "SH"."PROD_MV" does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_IREFRESH", line 159
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2996
ORA-06512: at line 1


SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101007=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:57 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> 
no rows selected

SQL> 
no rows selected

SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101008=0.2


A: 0


******************** TOPIC 2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:57 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200002=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200002=0


C: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200002=0


D: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200002=0


E: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200002=0


F: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:59 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R200003=0


A: 0


******************** TOPIC 3 ********************


******************** TOPIC 3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:00 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:00 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301003=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301003=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301003=0


C: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301003=0


D: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301003=0


E: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301003=0


F: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301004=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301004=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301004=0


C: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301004=0


D: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:03 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> select count(*) from sh.prod_master
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301005=0


VALUE_A: 


R301005=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:04 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301006=0


A: 0


******************** TOPIC 4 ********************


******************** TOPIC 4.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:04 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:04 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:05 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> ERROR:
ORA-04043: object sh.COUNTRIES_EXT does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401003=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:05 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> ERROR:
ORA-04043: object sh.COUNTRIES_EXT does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401003=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:05 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> ERROR:
ORA-04043: object sh.COUNTRIES_EXT does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401003=0


C: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:05 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> select	(select count(*) from sh.COUNTRIES_EXT) -(select count(*)  from SH.COUNTRIES) count from dual
                                 *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401004=0


VALUE_A: ERROR at line 1:


R401004=0.6



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:06 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> select count(*) from sh.COUNTRIES_EXT
                        *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R999999=0


VALUE_A: ERROR at line 1:


R999999=0


v_ext_num=0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:06 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>   2  
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401005=0


A: 0


******************** TOPIC 4.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:07 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:07 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:08 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> ERROR:
ORA-04043: object system.COUNTRIES_EXT does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402003=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:08 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> ERROR:
ORA-04043: object system.COUNTRIES_EXT does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402003=0


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:08 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> ERROR:
ORA-04043: object system.COUNTRIES_EXT does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402003=0


C: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:09 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> select count(*) from system.COUNTRIES_EXT
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402004=0


VALUE_A: ERROR at line 1:


R402004=0.4



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:21:09 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL>   2  
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402005=0


A: 0
****************************************************************************************************


R101001: 0 full is 0.2 0.2
R101002: 0 full is 0.5 0.7
R101003: 0 full is 0.5 1.2
R101004: 0 full is 0.2 1.4
R101005: 0 full is 0.2 1.6
R101006: 0 full is 0.2 1.8
R101007: 0 full is 0.5 2.3
R101008: 0.2 full is 0.2 2.5
R200001: 0 full is 0.2 2.7
R200002: 0 full is 1.2 3.9
R200003: 0 full is 0.6 4.5
R301001: 0 full is 0.4 4.9
R301002: 0 full is 0.2 5.1
R301003: 0 full is 0.6 5.7
R301004: 0 full is 0.4 6.1
R301005: 0 full is 0.6 6.7
R301006: 0 full is 0.3 7.0
R401001: 0 full is 0.4 7.4
R401002: 0 full is 0.2 7.6
R401003: 0 full is 0.3 7.9
R401004: 0.6 full is 0.6 8.5
R401005: 0 full is 0.1 8.6
R402001: 0 full is 0.4 9.0
R402002: 0 full is 0.2 9.2
R402003: 0 full is 0.3 9.5
R402004: 0.4 full is 0.4 9.9
R402005: 0 full is 0.1 10
full of this section:
RESULT:
1.2


****************************************************************************************************
