Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Database Security Applications And Trends

Authors: Michael Gertz, Sushil Jajodia

1st Edition

1441943056, 978-1441943057

More Books

Students also viewed these Databases questions