【正文】
023 Global Business Solutions, Inc.Transportable TablespacesSystem TablespaceTransportable TablespaceSystem Tablespace ExportImportCopyUtilityTransportable TablespaceSource DatabaseTarget DatabaseCopyright 169。 2023 Global Business Solutions, Inc.Define Database ObjectsOBJECTIVESn Define Tablespacesn Define Tables and Indexesn Define Segments, Extents, and BlocksCopyright 169。 2023 Global Business Solutions, Inc.Online and Offline Tablespacesn Onlinel Available to applicationsl Typically tablespaces onlinen Offlinel Not available to users, even if database is availablel Use for maintenance, troubleshooting, or historical data no longer neededOnlineOfflineCopyright 169。 2023 Global Business Solutions, Inc.LOB Typesn CLOB stores character datan NCLOB stores doublebyte character datan BLOB stores binary data: graphics, video, soundn BFILE stores pointers to external filesExternal File SystemCustomersName … History Photo GreetingGee Copyright 169。 2023 Global Business Solutions, Inc.Bitmap Indexn Bitmap created for each column valuen Common Usagel Very Large Tablesl LowCardinality Columnsn Featuresl Requires minimal storagel Improves performance‘F’BILLLISAANNTED1 00 10 11 0‘M’GENDERCopyright 169。 2023 Global Business Solutions, Inc.Index Organized Tablesn Data stored with B*Tree indexn Table must have primary key, which acts as indexn Appropriate for plex or unstructured datal Spatiall OLAPDataDataData90009999DataDataDataDataDataData3001400149990000020234000DataDataData5000700090005000799900002999Copyright 169。 2023 Global Business Solutions, Inc.Rollback Segment Usagen Undo data is written to segmentn Each extent supports multiple transactionsn Each transaction writes to its own block(s)n If extent fills, automatically extendsn If all extents fill, segment wrapsn If segment wraps, undo data overwrittenn If undo data not available, error occurs“Snapshot too old”“Cannot allocate extent”Copyright 169。 2023 Global Business Solutions, Inc.演講完畢,謝謝觀看!。 2023 Global Business Solutions, Inc.Temporary Segmentsn Provide temporary workspacen Created automatically for joins, indexes, sortsn Created on disk when memory fulln Sized by DEFAULT STORAGE clause of tablespacen Reclaimed by SMONBootstrapSegmentRollbackSegmentIndexSegment Temporary SegmentCopyright 169