26.oracleocp題庫dba經(jīng)典輔助學(xué)習(xí)

1、Storage StructuresObjectivesAfter completing this lesson, you should be able to do the following:Define the purpose of tablespaces and data filesCreate tablespacesManage tablespacesObtain tablespace informationTablespaces and Data FilesOracle stores data logically in tablespaces and physically in da

2、ta files.Tablespaces:Can belong to only one database at a timeConsist of one or more data files Are further divided into logical units of storage Data files:Can belong to only one tablespace and one databaseAre a repository for schema object dataDatabaseTablespaceData filesSpace Management in Tables

3、pacesLocally managed tablespace:Free extents are managed in the tablespace.Bitmap is used to record free extents. Each bit corresponds to a block or group of blocks.Bit value indicates free or used.Dictionary-managed tablespace:Free extents are managed by the data dictionary.Appropriate tables are u

4、pdated when extents are allocated or deallocated.Creating a New TablespaceCreating a New TablespaceFull Notes PageStorage for Locally Managed TablespacesStorage for Locally Managed Tablespaces Full Notes PageTablespaces in the Preconfigured DatabaseSYSTEMSYSAUXTEMPUNDOTBS1USERSEXAMPLETablespaces in

5、the Pre-Configured Database Full Notes PageAltering a TablespaceAltering a Tablespace Full Notes PageActions with TablespacesActions with TablespacesFull Notes PageDropping TablespacesViewing Tablespace InformationSummaryIn this lesson, you should have learned how to:Use tablespaces to separate dataCreate various types of tablespacesManage tablespacesObtain tablespace informationPractice 6: Working with TablespacesThis practice covers the following topics:Creating tablespacesGa