YoucreatedtheDEPTtablebyusingthefollowing&
YoucreatedtheDEPTtablebyusingthefollowingcommand:
CREATETABLEscott.dept
(deptnoNUMBER(3),
dnameVARCHAR2(15),
locVARCHAR2(15))
STORAGE(INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4);YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation,youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable?()
时间:2023-08-25 23:15:01
相似题目