Question: Database Question: Use SQL*Plus to test a tablespace configuration with multiple datafiles 1.Create a tablespace with one datafile. Use a uniform extent of 40 KB.

Database Question:

Use SQL*Plus to test a tablespace configuration with multiple datafiles

1.Create a tablespace with one datafile. Use a uniform extent of 40 KB.

2.Create three tables in this tablespace, and manually allocate 3 extents to each in turn (a total of 9 extents).

3. Run a query against DBA_EXTENTS to find the physical location of each extent for each table.

4. Add a second datafile to the tablespace.

5. Manually allocate 2 more extents in turn to each table (a total of 6).

6. Re-run the same query over DBA_EXTENTS.

7. Manually allocate 3 more extents to first table, followed by 1 extent to the second table.

8. Re-run the same query over DBA_EXTENTS.

9. Tidy up by dropping the new tablespace with contents and datafiles.

I need answer for each steps, appreciate it !!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!