|
|
我的输出：
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section4 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** TOPIC 1 ********************
export ORACLE_SID=PROD
.bash_profile OK
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH HOME/bin
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/jdk/binORACLE_HOME/binPATH
export LANG=en_US
******************** TOPIC 1.1 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:18 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> 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_MV2 SELECT time_id,prod_subcategory,SUM(unit_cost) FROM sh.costs c,sh.products p where c.prod_id=p.prod_id GROUP BY time_id,prod_subcategory
PROD_MV SELECT SH.PRODUCTS.PROD_SUBCATEGORY C1, SH.COSTS.TIME_ID C2, SUM("SH"."COSTS"."UNIT_COST") M1, COUNT("SH"."COSTS"."UNIT_COST") M2, COUNT(*) M3 FROM SH.PRODUCTS, SH.COSTS WHERE SH.COSTS.PROD_ID = SH.PRODUCTS.PROD_ID GROUP BY SH.PRODUCTS.PROD_SUBCATEGORY, SH.COSTS.TIME_ID
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 SH.PRODUCTS.PROD_SUBCATEGORY C1, SH.COSTS.TIME_ID C2, SUM("SH"."COSTS"."UNIT_COST") M1, COUNT("SH"."COSTS"."UNIT_COST") M2, COUNT(*) M3 FROM SH.PRODUCTS, SH.COSTS WHERE SH.COSTS.PROD_ID = SH.PRODUCTS.PROD_ID GROUP BY SH.PRODUCTS.PROD_SUBCATEGORY, SH.COSTS.TIME_ID
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:18 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> 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_MV2 SELECT time_id,prod_subcategory,SUM(unit_cost) FROM sh.costs c,sh.products p where c.prod_id=p.prod_id GROUP BY time_id,prod_subcategory
PROD_MV SELECT SH.PRODUCTS.PROD_SUBCATEGORY C1, SH.COSTS.TIME_ID C2, SUM("SH"."COSTS"."UNIT_COST") M1, COUNT("SH"."COSTS"."UNIT_COST") M2, COUNT(*) M3 FROM SH.PRODUCTS, SH.COSTS WHERE SH.COSTS.PROD_ID = SH.PRODUCTS.PROD_ID GROUP BY SH.PRODUCTS.PROD_SUBCATEGORY, SH.COSTS.TIME_ID
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.5
A: PROD_MV SELECT SH.PRODUCTS.PROD_SUBCATEGORY C1, SH.COSTS.TIME_ID C2, SUM("SH"."COSTS"."UNIT_COST") M1, COUNT("SH"."COSTS"."UNIT_COST") M2, COUNT(*) M3 FROM SH.PRODUCTS, SH.COSTS WHERE SH.COSTS.PROD_ID = SH.PRODUCTS.PROD_ID GROUP BY SH.PRODUCTS.PROD_SUBCATEGORY, SH.COSTS.TIME_ID
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:18 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> 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_MV2 SELECT time_id,prod_subcategory,SUM(unit_cost) FROM sh.costs c,sh.products p where c.prod_id=p.prod_id GROUP BY time_id,prod_subcategory
PROD_MV SELECT SH.PRODUCTS.PROD_SUBCATEGORY C1, SH.COSTS.TIME_ID C2, SUM("SH"."COSTS"."UNIT_COST") M1, COUNT("SH"."COSTS"."UNIT_COST") M2, COUNT(*) M3 FROM SH.PRODUCTS, SH.COSTS WHERE SH.COSTS.PROD_ID = SH.PRODUCTS.PROD_ID GROUP BY SH.PRODUCTS.PROD_SUBCATEGORY, SH.COSTS.TIME_ID
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: 2
R101003=0.5
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:18 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 Sat Sep 12 21:36:19 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 Sat Sep 12 21:36:19 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
1 row updated.
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
R101006=0.2
A: 0
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:20 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
P
-
Y
Y
Y
Y
Y
Y
6 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
R101007=0.5
A: 0
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:20 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
OWNER NAME COLUMN_NAME
------------------------------ ------------------------------ ------------------------------
SH COSTS PROD_ID
SH COSTS TIME_ID
SH COSTS UNIT_COST
SQL>
OWNER NAME COLUMN_NAME
------------------------------ ------------------------------ ------------------------------
SH PRODUCTS PROD_ID
SH PRODUCTS PROD_SUBCATEGORY
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 YES NO 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 Sat Sep 12 21:36:20 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL>
MVIEW_NAME
------------------------------
EMP_UPD_MV
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.2
A: EMP_UPD_MV
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:21 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL> SQL> SQL>
QUERY
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
from hr.employees@dblink1
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.2
A: select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:21 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL> SQL> SQL>
QUERY
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
from hr.employees@dblink1
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=.4
B: select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:21 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL> SQL> SQL>
QUERY
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
from hr.employees@dblink1
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=.6
C: select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:21 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL> SQL> SQL>
QUERY
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
from hr.employees@dblink1
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=.8
D: select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:21 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL> SQL> SQL>
QUERY
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
from hr.employees@dblink1
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=1.0
E: select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:21 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL> SQL> SQL>
QUERY
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,PHONE_NUMBER,SALARY
from hr.employees@dblink1
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=1.2
F: from hr.employees@dblink1
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:22 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL>
U
-
Y
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.6
A: Y
******************** TOPIC 3 ********************
******************** TOPIC 3.1 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:22 2015
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 Sat Sep 12 21:36:23 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 Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
" ROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"ROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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.1
A: "ROD_ID" CHAR(255)
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"ROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"ROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.2
B: "CUST_ID" CHAR(255)
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"ROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"ROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.3
C: "TIME_ID" CHAR(11)
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"ROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"ROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.4
D: "CHANNEL_ID" CHAR(255)
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"ROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"PROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.5
E: "PROMO_ID" CHAR(255)
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"PROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"PROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.6
F: "QUANTITY_SOLD" CHAR(255)
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"PROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"PROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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.1
A: "AMOUNT_SOLD" CHAR(255)
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"PROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"PROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.2
B: DATE_FORMAT DATE MASK "DD-MON-YYYY",
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"PROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"PROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.3
C: FIELDS TERMINATED BY "|" LDRTRIM
TERMINATED BY "|",
TERMINATED BY "|",
TERMINATED BY "|"
TERMINATED BY "|",
TERMINATED BY "|",
TERMINATED BY "|",
TERMINATED BY "|"
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:23 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
RECORDS DELIMITED BY NEWLINE
BADFILE dir1:'prod_master.bad'
LOGFILE dir1:'prod_master.log'
READSIZE 1048576
FIELDS TERMINATED BY "|" LDRTRIM
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
(
"PROD_ID" CHAR(255)
TERMINATED BY "|",
"CUST_ID" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|",
"TIME_ID" CHAR(11)
TERMINATED BY "|"
DATE_FORMAT DATE MASK "DD-MON-YYYY",
"CHANNEL_ID" CHAR(255)
TERMINATED BY "|",
"PROMO_ID" CHAR(255)
TERMINATED BY "|",
"QUANTITY_SOLD" CHAR(255)
TERMINATED BY "|",
"AMOUNT_SOLD" CHAR(255)
ACCESS_PARAMETERS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TERMINATED BY "|"
)
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=.4
D: MISSING FIELD VALUES ARE NULL
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:25 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
COUNT(*)
----------
79130
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: 79130
R301005=0.6
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:26 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 Sat Sep 12 21:36:26 2015
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 Sat Sep 12 21:36:26 2015
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 Sat Sep 12 21:36:27 2015
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 Sat Sep 12 21:36:27 2015
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 Sat Sep 12 21:36:27 2015
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 Sat Sep 12 21:36:27 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
R401004=0.6
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:28 2015
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 Sat Sep 12 21:36:28 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL> 2
PATH
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/home/oracle/labs/COUNTRIES_EXT.dmp
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: 0
******************** TOPIC 4.2 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:28 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 Sat Sep 12 21:36:29 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 Sat Sep 12 21:36:29 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 Sat Sep 12 21:36:29 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 Sat Sep 12 21:36:29 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 Sat Sep 12 21:36:30 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL>
COUNT(*)
----------
23
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
R402004=0.4
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 21:36:30 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> SQL> Connected.
SQL> 2
PATH
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/home/oracle/labs/COUNTRIES_EXT.dmp
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: 0
****************************************************************************************************
R101001: 0.2 full is 0.2 0.2
R101002: 0.5 full is 0.5 0.7
R101003: 0.5 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.2 full is 0.2 1.8
R101007: 0.5 full is 0.5 2.3
R101008: 0.2 full is 0.2 2.5
R200001: 0.2 full is 0.2 2.7
R200002: 1.2 full is 1.2 3.9
R200003: 0.6 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: .6 full is 0.6 5.7
R301004: .4 full is 0.4 6.1
R301005: 0.6 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.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:
10.0
****************************************************************************************************
|
|
发表于 2015-10-9 17:05:46
