oracle對(duì)象定義(英文版)-wenkub
2023-02-24 07:35:33 本頁面
【正文】 F 2 Zachary’s 1234 BrCopyright 169。 2023 Global Business Solutions, Inc.Large Object Datatypen Store Unstructured Informationl Text documentsl Static imagesl Videol AudioCustomersName Address... Photo Greeting Gee.. 123 Cherry Copyright 169。 2023 Global Business Solutions, Inc.Transportable TablespacesSystem TablespaceTransportable TablespaceSystem Tablespace ExportImportCopyUtilityTransportable TablespaceSource DatabaseTarget DatabaseCopyright 169。 2023 Global Business Solutions, Inc.System and Nonsystem Tablespacesn Systeml At least onel Data Dictionaryl Rollbackn Nonsysteml Facilitates Administrationl User/Application Data, Indexesl Rollback and Temporary SegmentsCopyright 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.Define Database Objects OverviewDatabaseTablespaceTables, indexes, etc. DatafilesSegmentExtentBlocksCopyright 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.Uses of Transportable Tablespacesn Archive OLTP and data warehouse systemsn Transfer data from OLTP to data warehouse staging systemsn Loading data marts from central data warehousesn Publish datan Move index data and avoid rebuildsCopyright 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.Index Typesn Uniquel Duplicates not allowedn Nonuniquel Duplicates allowedXCopyright 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’GENDE
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1