

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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 PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US
export ORACLE_SID=PROD
export TNS_ADMIN=$ORACLE_HOME/network/admin


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

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:32 2003

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 Fri Jan 3 10:36:32 2003

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 Fri Jan 3 10:36:32 2003

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 Fri Jan 3 10:36:32 2003

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 Fri Jan 3 10:36:33 2003

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 Fri Jan 3 10:36:33 2003

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 Fri Jan 3 10:36:33 2003

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 Fri Jan 3 10:36:34 2003

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

SQL> Connected.
SQL> SQL> 
OWNER			       NAME			      COLUMN_NAME
------------------------------ ------------------------------ ------------------------------
SH			       COSTS			      CHANNEL_ID
SH			       COSTS			      PROD_ID
SH			       COSTS			      PROMO_ID
SH			       COSTS			      TIME_ID
SH			       COSTS			      UNIT_COST
SH			       COSTS			      UNIT_PRICE

6 rows selected.

SQL> 
OWNER			       NAME			      COLUMN_NAME
------------------------------ ------------------------------ ------------------------------
SH			       PRODUCTS 		      PROD_CATEGORY
SH			       PRODUCTS 		      PROD_CATEGORY_DESC
SH			       PRODUCTS 		      PROD_CATEGORY_ID
SH			       PRODUCTS 		      PROD_DESC
SH			       PRODUCTS 		      PROD_EFF_FROM
SH			       PRODUCTS 		      PROD_EFF_TO
SH			       PRODUCTS 		      PROD_ID
SH			       PRODUCTS 		      PROD_LIST_PRICE
SH			       PRODUCTS 		      PROD_MIN_PRICE
SH			       PRODUCTS 		      PROD_NAME
SH			       PRODUCTS 		      PROD_PACK_SIZE

OWNER			       NAME			      COLUMN_NAME
------------------------------ ------------------------------ ------------------------------
SH			       PRODUCTS 		      PROD_SRC_ID
SH			       PRODUCTS 		      PROD_STATUS
SH			       PRODUCTS 		      PROD_SUBCATEGORY
SH			       PRODUCTS 		      PROD_SUBCATEGORY_DESC
SH			       PRODUCTS 		      PROD_SUBCATEGORY_ID
SH			       PRODUCTS 		      PROD_TOTAL
SH			       PRODUCTS 		      PROD_TOTAL_ID
SH			       PRODUCTS 		      PROD_UNIT_OF_MEASURE
SH			       PRODUCTS 		      PROD_VALID
SH			       PRODUCTS 		      PROD_WEIGHT_CLASS
SH			       PRODUCTS 		      SUPPLIER_ID

22 rows selected.

SQL> 
LOG_OWNER		       MASTER			      LOG_TABLE 		     LOG_TRIGGER		    ROW PRI OBJ FIL SEQ INC
------------------------------ ------------------------------ ------------------------------ ------------------------------ --- --- --- --- --- ---
SH			       COSTS			      MLOG$_COSTS						    YES NO  NO	YES NO	NO

SQL> 
LOG_OWNER		       MASTER			      LOG_TABLE 		     LOG_TRIGGER		    ROW PRI OBJ FIL SEQ INC
------------------------------ ------------------------------ ------------------------------ ------------------------------ --- --- --- --- --- ---
SH			       PRODUCTS 		      MLOG$_PRODUCTS						    YES YES NO	YES YES YES

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 Fri Jan 3 10:36:34 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:34 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SQL> SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:34 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SQL> SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200002=0.2


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:34 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SQL> SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200002=.30


C: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:34 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SQL> SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200002=.32


D: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:34 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SQL> SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200002=.34


E: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:34 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SQL> SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200002=.37


F: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:35 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R200003=0


A: 0


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
TABLE_NAME
------------------------------
PROD_MASTER
COUNTRIES_EXT

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.4


A: PROD_MASTER

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
TYPE_NAME
------------------------------
ORACLE_LOADER

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.2


A: ORACLE_LOADER

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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 Fri Jan 3 10:36:36 2003

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

SQL> Connected.
SQL> SQL> 
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
    BADFILE mydir1:'prod_master.bad'
    LOGFILE 'prod_master.log_xt'
    READSIZE 1048576
    FIELDS TERMINATED BY WHITESPACE LDRTRIM
    MISSING FIELD VALUES ARE NULL
    REJECT ROWS WITH ALL NULL FIELDS
    (
      "EMP_NO" CHAR(255)
       TERMINATED BY WHITESPACE,
      "DEPT_NO" CHAR(255)

ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
       TERMINATED BY WHITESPACE,
      "NAME" CHAR(255)
       TERMINATED BY WHITESPACE,
      "NUM" CHAR(255)
       TERMINATED BY WHITESPACE
    )



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=.1


D:     MISSING FIELD VALUES ARE NULL

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:38 2003

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

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 0

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
VALUE_A: 	 0


R301005=0



SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:42 2003

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

SQL> Connected.
SQL> SQL> 
LOCATION
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
prod_master.dat

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.3


A: prod_master.dat


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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:42 2003

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

SQL> Connected.
SQL> SQL> 
TABLE_NAME
------------------------------
PROD_MASTER
COUNTRIES_EXT

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.4


A: COUNTRIES_EXT

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:42 2003

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

SQL> Connected.
SQL> SQL> 
TYPE_NAME
------------------------------
ORACLE_DATAPUMP

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.2


A: ORACLE_DATAPUMP

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:43 2003

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 COUNTRY_ID																																																																									   NOT NULL NUMBER
 COUNTRY_NAME																																																																									   NOT NULL VARCHAR2(40)
 COUNTRY_REGION 																																																																								   NOT NULL VARCHAR2(20)

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.1


A:  COUNTRY_ID																																																																									   NOT NULL NUMBER

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:43 2003

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 COUNTRY_ID																																																																									   NOT NULL NUMBER
 COUNTRY_NAME																																																																									   NOT NULL VARCHAR2(40)
 COUNTRY_REGION 																																																																								   NOT NULL VARCHAR2(20)

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=.2


B:  COUNTRY_NAME																																																																									   NOT NULL VARCHAR2(40)

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:43 2003

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

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 COUNTRY_ID																																																																									   NOT NULL NUMBER
 COUNTRY_NAME																																																																									   NOT NULL VARCHAR2(40)
 COUNTRY_REGION 																																																																								   NOT NULL VARCHAR2(20)

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=.3


C:  COUNTRY_REGION 																																																																								   NOT NULL VARCHAR2(20)

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:43 2003

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

SQL> Connected.
SQL> SQL> 
     COUNT
----------
	 0

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
VALUE_A: 	 0


R401004=0.6



SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:44 2003

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

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	23

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
VALUE_A: 	23


R999999=0


v_ext_num=23

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:44 2003

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

SQL> Connected.
SQL> SQL>   2  
PATH
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/home/oracle//COUNTRIES_EXT.dat

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.1


A: /home/oracle//COUNTRIES_EXT.dat


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

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:44 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R402001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:44 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R402002=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:44 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SP2-0641: "DESCRIBE" requires connection to server
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R402003=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:44 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SP2-0641: "DESCRIBE" requires connection to server
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R402003=0.1


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:44 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SP2-0641: "DESCRIBE" requires connection to server
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R402003=.2


C: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:45 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL> SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

R402004=0


VALUE_A: 


R402004=0



SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 10:36:45 2003

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

SQL> SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


SQL>   2  SP2-0640: Not connected
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 

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: .37 full is 1.2 3.9
R200003: 0 full is 0.6 4.5
R301001: 0.4 full is 0.4 4.9
R301002: 0.2 full is 0.2 5.1
R301003: 0 full is 0.6 5.7
R301004: .1 full is 0.4 6.1
R301005: 0 full is 0.6 6.7
R301006: 0.3 full is 0.3 7.0
R401001: 0.4 full is 0.4 7.4
R401002: 0.2 full is 0.2 7.6
R401003: .3 full is 0.3 7.9
R401004: 0.6 full is 0.6 8.5
R401005: 0.1 full is 0.1 8.6
R402001: 0 full is 0.4 9.0
R402002: 0 full is 0.2 9.2
R402003: .2 full is 0.3 9.5
R402004: 0 full is 0.4 9.9
R402005: 0 full is 0.1 10
full of this section:
RESULT:
3.37


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