Explore BrainMass
Share

Explore BrainMass

    Assessing the Oracle9i Database

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Recall that you created this table for Global Globe's employees:
    CREATE TABLE EMPLOYEE
    (EMPLOYEE_ID NUMBER(10),
    JOB_TITLE VARCHAR2(45),
    first_name varchar2(40),
    Last_name varchar2(40),
    phone_number Varchar2(20));

    Start with this CREATE TABLE command, and modify it to create a new range_partitioned table named CH07EMPLOYEE_RANGE that contains the same column as the employee table. The partition key is the EMPLOYEE_ID column, and there should be four partitions, all located in the USERS tablespace. Assume that the values in EMPLOYEE_ID start at one, reach 100,000, and are distributed evenly. Save the command in a file.

    © BrainMass Inc. brainmass.com May 20, 2020, 2:34 pm ad1c9bdddf
    https://brainmass.com/computer-science/files/assessing-oracle9i-database-93611

    Attachments

    Solution Preview

    Recall that you created this table for Global Globe's employees:
    CREATE TABLE EMPLOYEE
    (EMPLOYEE_ID NUMBER(10),
    JOB_TITLE VARCHAR2(45),
    first_name varchar2(40),
    Last_name varchar2(40),
    phone_number Varchar2(20));

    Start with this CREATE TABLE command, and modify it to create a new range_partitioned ...

    Solution Summary

    This solution helps with a problem involving assessing data with the Oracle9i Database.

    $2.19

    ADVERTISEMENT