1表空间及其管理

《1表空间及其管理》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、Src:Oracle8/ConceptsTablespacesandDatafiles•IntroductiontoDatabases,Tablespaces,andDatafiles•Tablespaces•DatafilesIntroductiontoDatabases,Tablespaces,andDatafiles•Oraclestoresdatalogicallyintablespacesandphysicallyindatafilesassociatedwiththecorrespondingtablespace.JTable

2、space,•on?ormor*DatafileObjKlsndatabasesandAnOracledatabaseconsistsofoneormorelogicaltablespacesstorageunitscalledtablespacestablespacesanddatafilesEachtablespaceinanOracledatabaseconsistsofoneormorefilescalleddatafilesdatabasesanddatafilesAdatabase"sdataiscollectivelysto

3、redinthedatafilesAllocatingMoreSpaceforaDatabase(threeways)•Addanewtablespace•Addadatafiletoatablespace•Increasethesizeofadatafilefre?jndwthd———————————q—iSystemTablespaceiiUSERSTablespaceIDATA1.ORAMTA2.ORA

4、

5、&ATAXORAALTET：Ds^TAB^SE：D^T^FILEBDAl%5.OFArWT0s^rei«>o»riikt二伽2隘

6、孟SENtoo^1:Tablespaces•Tablespacesaredividedintologicalunitsofstoragecalledsegments、whicharefurtherdividedintoextents.•TheSYSTEMTablespace•UsingMultipleTablespaces•SpaceManagementinTablespaces•OnlineandOfflineTablespaces•Read-OnlyTablespaces•TemporaryTablespaces•Transporti

7、ngTablespacesbetweenDatabasesTheSYSTEMTablespace•EveryOracledatabasecontainsatablespacenamedSYSTEM,whichOraclecreatesautomaticallywhenthedatabaseiscreated.TheDataDictionary•TheSYSTEMtablespacecontainsthedatadietionarytablesforthedatabase.Thedatadictionarytablesarestoredin

8、datafile1.PL/SQLProgramUnits•AlldatastoredonbehalfofstoredPL/SQLprogramunits(procedures,functions,packages,andtriggers)residesintheSYSTEMtablespace.UsingMultipleTablespaces•AsmalldatabasemightneedonlytheSYSTEMtablespace•Youshouldcreateatleastoneadditionaltablespacetostore

9、userdataseparatefromdatadictionaryinformation•Youcanusemultipietablespacesto:1.Controldiskspaceallocationfordatabasedata2.Assignspecificspacequotasfordatabaseusers3.Controlavailabilityofdatabytakingtablespacesonlineoroffline1.Performpartialdatabasebackuporrecoveryoperatio

10、ns2.AllocatedatastorageacrossdevicestoimproveperformanceSpaceManagementinTablespaces•Tablespaces