Explore BrainMass

Explore BrainMass

    Problems Involving Oracle9i Database

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

    2. Create SQL script that completes the following task successfully.
    1. Create a locally-managed tablespace named HANDS_62 with one 10 M OMF datafile in the directory name of your choice.
    2. Add another 25 M datafile (OMF) to the tablespace.
    3. Query the Data Dictionary, and display the total available space in the tablespace.
    4. Make the tablespace read only, and take it offline.
    5. Drop the tablespace.

    © BrainMass Inc. brainmass.com June 3, 2020, 7:18 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/problems-involving-oracle9i-database-92831

    Attachments

    Solution Preview

    CHECK ATTACHMENT.

    -------------------
    2. Create SQL script that completes the following task successfully.

    1. Create a locally-managed tablespace named HANDS_62 with one 10 M OMF datafile in the directory name of your ...

    Solution Summary

    This solution involves problems with the Oracle9i database.

    $2.19

    ADVERTISEMENT