YoucreatedtheDEPTtablebyusingthefollowing&

YoucreatedtheDEPTtablebyusingthefollowingcommand: CREATETABLEscott.dept (deptnoNUMBER(3), dnameVARCHAR2(15), locVARCHAR2(15)) STORAGE(INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4);YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation,youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable?()

时间:2023-08-25 23:15:01

相似题目