7-ASSIGNMENTS ON TABLESPACES AND DATAFILES (2)

7-ASSIGNMENTS ON TABLESPACES AND DATAFILES (2) - make the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ASSIGNMENTS ON TABLESPACES AND DATAFILES 1.Create permanent tablespace with the following names and storage a) DATA01 data dictionary managed b) DATA02 locally managed with uniform sized extents (Ensure that every used extent size in the tablespace is a multiple of 10K) c) INDX01 locally managed with uniform sized extents of 4K (Enable automatic extension of 50K when more extents are required with a maximum size of 2MB) d) RONLY for read-only tables with default storage. DO NOT
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: make the tablespace read only at this time. e) Display information about the tablespaces created 2.Allocate 500K more disk space to tablespace DATA02. Verify the result 3.Realocate tablespace INDX01 to subdirectory mydir under the oracle home. 4.Create a table in tablespace RONLY. Make tablespace RONLY read-only. Attempt to create an additional table. Drop the first created table. What happens and why? 5.Drop tablespace RONLY and the associated datafile. Verify it....
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online