Oracle Network Administration
Oracle Net Features
Net Listener Features
Net Scalability Features
Oracle Partitioned Tables
Net Connectivity Features
Oracle Manageability Features
Oracle Security Features
Net Services Installation
Net Pre Installation
Add Net Features
Net Listener OEM
Net Configuration Assistant
Using Connection Manager
Net Multiplexing Configuration
Understanding Connection Pooling
Configure Loadbalancing Network
Radius Adapter Purpose
Configure Radius Adapter
Distributed Database Server
Oracle Queue Propagation
Using Primary Key Snapshots
Implement Snapshot Security
Instantiating Snapshot Sites Offline
Partitioning Index Organized Tables
Partitioning Object Tables
Enabling Row Movement
Enable Row Movement
Exchange Partition with Table
Exchange Table Partition
Partitionwise Queries Joins
Enabling Partition Wise-join
Using Parallel Queries on Object Tables - Exercise
Course Project: Create parallel DML and parallel query
Create a query and create DML commands for a table.
This scored exercise is worth 10 points.
In this exercise, you will create a parallel DML command for a table and create a parallel query for an object table.
House-O-Pets Data Warehouse
Review the schema diagram below to find out more information about the House-O-Pets data warehouse.
View the diagram below.
You can download a beginning version of the script for this exercise, parallel.sql, from the Resources page.
Here is what is going on at House-O-Pets: you have just set up a data warehouse system that contains copies of all your customer transactions in several new partitioned tables. You want to update all the warehouse customer records with a timestamp to record when you added the records into the data warehouse. You also want to run a parallel query on the customer object table that sorts customers by their purchase amounts.
Starting with the code in your downloaded file, modify the file to complete these tasks:
Add a parallel update of the
table. Update the WAREHOUSE_DATE column with the current date and time.
that returns the TOTAL_SALE_AMOUNT column.
Add a parallel query on the
object table that lists the customer’s name and purchase amount, sorted by the
Submitting your exercise
Type (or cut and paste) your plan into the box below to submit your answers . Click the
button when finished to submit the exercise. Remember to submit all of your answers at once.