

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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:/u01/app/oracle/product/10.2.0/db_1/jdk/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 ORACLE_SID=PROD
export GLOGAL_DBNAME=PROD
export LANG=en_US


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:31 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


MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
PROD_MV 		       SELECT time_id,prod_subcategory,SUM(unit_cost) FROM sh.costs c,sh.products p whe
			       re c.prod_id=p.prod_id GROUP BY time_id,prod_subcategory


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


A: PROD_MV 		       SELECT time_id,prod_subcategory,SUM(unit_cost) FROM sh.costs c,sh.products p whe

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:31 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


MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
PROD_MV 		       SELECT time_id,prod_subcategory,SUM(unit_cost) FROM sh.costs c,sh.products p whe
			       re c.prod_id=p.prod_id GROUP BY time_id,prod_subcategory


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:31 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


MVIEW_NAME		       QUERY
------------------------------ --------------------------------------------------------------------------------
PROD_MV 		       SELECT time_id,prod_subcategory,SUM(unit_cost) FROM sh.costs c,sh.products p whe
			       re c.prod_id=p.prod_id GROUP BY time_id,prod_subcategory


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:32 2015

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

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

SQL> 
Commit complete.

SQL> 
PL/SQL procedure successfully completed.

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


A: 0

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

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

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

SQL> 
Commit complete.

SQL> 
PL/SQL procedure successfully completed.

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


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 21:20:33 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-12032: cannot use rowid column from materialized view log on "SH"."PRODUCTS"
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:34 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> 
PL/SQL procedure successfully completed.

SQL> 
CAPABILITY_NAME 	       P
------------------------------ -
REFRESH_COMPLETE	       Y
REFRESH_FAST		       Y
REFRESH_FAST_AFTER_INSERT      N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ANY_DML     N
REFRESH_FAST_PCT	       Y

9 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: REFRESH_FAST_AFTER_INSERT      N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ONETAB_DML  N
REFRESH_FAST_AFTER_ANY_DML     N

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

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 YES YES

SQL> 
LOG_OWNER		       MASTER			      LOG_TABLE 		     LOG_TRIGGER		    ROW PRI OBJ FIL SEQ INC
------------------------------ ------------------------------ ------------------------------ ------------------------------ --- --- --- --- --- ---
SH			       PRODUCTS 		      MLOG$_PRODUCTS						    NO	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 Sun Jan 11 21:20:35 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:35 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:35 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:35 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:35 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:35 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:35 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:37 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:20:37 2015

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

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

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:38 2015

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 Sun Jan 11 21:20:40 2015

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 Sun Jan 11 21:20:44 2015

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 Sun Jan 11 21:20:44 2015

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

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

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:20:44 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:20:45 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:20:45 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:20:45 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:20:45 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:20:45 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:20:46 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:20:46 2015

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

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

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


A: COUNTRIES_EXT

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

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

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

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


A: ORACLE_DATAPUMP

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

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

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

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


A:  COUNTRY_ID																																																																										    NUMBER

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

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

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

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


B:  COUNTRY_NAME																																																																										    VARCHAR2(40)

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

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

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

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


C:  COUNTRY_REGION 																																																																									    VARCHAR2(20)

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

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

SQL> SQL> Connected.
SQL> select count(*) from system.COUNTRIES_EXT
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-11010: unable to open at least one dump file for load
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19


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:20:48 2015

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

SQL> SQL> Connected.
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> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402005=0.1


A: /home/oracle/COUNTRIES_EXT.dat
****************************************************************************************************


R101001: 0.2 full is 0.2 0.2
R101002: 0 full is 0.5 0.7
R101003: 0 full is 0.5 1.2
R101004: 0.2 full is 0.2 1.4
R101005: 0.2 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.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 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.4 full is 0.4 9.0
R402002: 0.2 full is 0.2 9.2
R402003: .3 full is 0.3 9.5
R402004: 0.4 full is 0.4 9.9
R402005: 0.1 full is 0.1 10
full of this section:
RESULT:
3.8


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