4. The following table resulted from the query SELECT * FROM DBA_FREE_SPACE. TABLE SPACE_ FILE_ID NAME SYSTEM 1 SYSTEM 1 2 3 3 DATA DATA DATA INDEX 4 BLOCK_ID BYTES BLOCKS RELATIVE_FNO 100 250 600 150 350 15 614400 921600 307200 614400 61440 307200 100 150 50 2 112334 100 10 50 Write the SQL statement that will defragment the free space in the DATA tablespace.
4. The following table resulted from the query SELECT * FROM DBA_FREE_SPACE. TABLE SPACE_ FILE_ID NAME SYSTEM 1 SYSTEM 1 2 3 3 DATA DATA DATA INDEX 4 BLOCK_ID BYTES BLOCKS RELATIVE_FNO 100 250 600 150 350 15 614400 921600 307200 614400 61440 307200 100 150 50 2 112334 100 10 50 Write the SQL statement that will defragment the free space in the DATA tablespace.
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 1HOA
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning