Question: Use SQL*Plus to test a tablespace configuration with multiple datafiles 50 points Create a tablespace with one datafile. Use a uniform extent of 40 KB.
Use SQL*Plus to test a tablespace configuration with multiple datafiles 50 points Create a tablespace with one datafile. Use a uniform extent of 40 KB. Create three tables in this tablespace, and manually allocate 3 extents to each in turn (a total of 9 extents). Run a query against DBA_EXTENTS to find the physical location of each extent for each table. Add a second datafile to the tablespace. Manually allocate 2 more extents in turn to each table (a total of 6). Re-run the same query over DBA_EXTENTS. Manually allocate 3 more extents to first table, followed by 1 extent to the second table. Re-run the same query over DBA_EXTENTS. Tidy up by dropping the new tablespace with contents and datafiles. (1) Provide all interaction with the database, all the SQL queries (create, drop, select, etc.) and their corresponding results.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
