oracle對(duì)象定義(英文版)-全文預(yù)覽
【正文】 pport database recoveryn A SYSTEM rollback segment is requiredBootstrapSegmentRollbackSegmentIndexSegmentRollback SegmentCopyright 169。 2023 Global Business Solutions, Inc.Storage Object and Segment Relationship n Create a storage object in tablespacen Tables, indexes, etc. are preallocated to segmentsSegmentExtentSegmentMySegmentBlocksCopyright 169。 2023 Global Business Solutions, Inc.Equipartitionsn Database objects have same logical partitionsn Examplesl Master and detail table l Table and indexOrder TableItem TableCustomer TableCustomer by State Copyright 169。Copyright 169。 2023 Global Business Solutions, Inc.Index Typesn MultiColumnl Concatenated, positeIndex RowidOrderNo ItemNo Block.Seq.File006989 001 006989 002 OrderNo ItemNo Cust.007000 001 USA007000 002 GBSI007000 003 TEST007234 005 WEST 006989 001 ABC 006989 002 XYZORDER TABLECopyright 169。 2023 Global Business Solutions, Inc.Temporary Tablesn Store session/ transaction specific datan Show data only to creating sessionn Discard data on mit or preserve data until session endsTablespace A Temp01 Temp02Copyright 169。 2023 Global Business Solutions, Inc.Table Datatypesn CHARn VARCHAR2n NUMBERn DATAn LOBCustomersName Address Phone…..Gee..123 Cherry 555 5555 Copyright 169。 2023 Global Business Solutions, Inc.Tips for ReadOnly Tablespacesn Organize by modification requirementsl Frequency of data changel Backup requirementl Security requirementl User requirementn Associated datafile cannot be:l Resized or have auto extend set to onl Renamed to a new datafile name or directoryl OfflineCopyright 169。 2023 Global Business Solutions, Inc.Types of Tablespacesn System/Nonsystemn Online/Offlinen ReadWrite/ReadOnlyn TransportableCopyright 169。Define Database ObjectsCopyright 169。 2023 Global Business Solutions, Inc.Tablespacesn Largest logical unit of spacen Consist of one or more datafilesn SYSTEM tablespace must existTablespaceCopyright 169。 2023 Global Business Solutions, Inc.ReadWrite and ReadOnly Tablespacesn ReadWritel Create, alter, and drop database objectsl Defaultn ReadOnlyl Cannot create or alter database objectsl Can drop certain objectsl Can reside on Worm device or CDROM l Eliminate redundant data backupsl Ideal for Data Warehouse applications and Lookup tablesReadWriteReadOnlyCopyright 169。 2023 Global Business Solutio
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1