Create a locally-managed tablespace


Discuss the below:

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.

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Create a locally-managed tablespace
Reference No:- TGS01939179

Now Priced at $25 (50% Discount)

Recommended (97%)

Rated (4.9/5)