Purchase Solution

Problems Involving Oracle9i Database

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution

Solution Summary

This solution involves problems with the Oracle9i database.

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 ...

Purchase this Solution


Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Networking Questions

This quiz consists of some basic networking questions.