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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started