you need to change to achieve your objective?

You want to unload data from the ORDERS, ORDER_ITEMS, and PRODUCTS database tables to four os flat files by using the External Table Population methods. To achieve this objective, you execute the following command:

Create TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext_dir
LOCATION (‘orders1.dmp’,’orders2.dmp’,’orders3.dmp’,’orders4.dmp’)
)
PARALLEL
AS
SELECT
o.order_id,o.order_date,p.product_id,p.product_name,i.quanity
FROM orders o,products p,order_items i
WHERE o.order_id = i.order_id and i.product_id = p.product_id;

After successful execution of the command, you find that only two files have been created and not four. Which option do you need to change to achieve your objective?

(Case Study):

You want to unload data from the ORDERS, ORDER_ITEMS, and PRODUCTS database tables to four os flat files by using the External Table Population methods. To achieve this objective, you execute the following command:

Create TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext_dir
LOCATION (‘orders1.dmp’,’orders2.dmp’,’orders3.dmp’,’orders4.dmp’)
)
PARALLEL
AS
SELECT
o.order_id,o.order_date,p.product_id,p.product_name,i.quanity
FROM orders o,products p,order_items i
WHERE o.order_id = i.order_id and i.product_id = p.product_id;

After successful execution of the command, you find that only two files have been created and not four. Which option do you need to change to achieve your objective?

(Case Study):

A.
TYPE

B.
LOCATION

C.
PARALLEL

D.
DEFAULT DIRECTORY

E.
ORGANIZATION EXTERNAL



Leave a Reply 0

Your email address will not be published. Required fields are marked *