【正文】 y 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.Transportable TablespacesSystem TablespaceTransportable TablespaceSystem Tablespace ExportImportCopyUtilityTransportable TablespaceSource DatabaseTarget DatabaseCopyright 169。 2023 Global Business Solutions, Inc.Partition Datan Depose tables and indexesn Each partition can be stored in different tablespaceCustomerCustNo CustName State…1 Kodak NY 4 Oracle CA 5 US Steel PA 6 Quest WA 7 Motorola TX Customers AL…INCustomers KS…NY Customers OH…WYCopyright 169。 2023 Global Business Solutions, Inc.Bootstrap Segmentn Contains dictionary definitions loaded on openn Is not user accessiblen Resides in SYSTEM tablespacen Requires no DBA maintenanceBootstrapSegmentRollbackSegmentIndexSegmentBootstrap SegmentCopyright 169。 2023 Global Business Solutions, Inc.Rollback Segment Typesn Privatel Must include segment name in ROLLBACK_SEGMENTS parametern Publicl A pool of rollback segments that may be acquired by any instance mounting databasen Deferredl Created in SYSTEM tablespace when tablespace taken offline and transactions cannot be rolled backCopyright 169。 2023 Global Business Solutions, Inc.Balanced Index Tree (B*Tree)ROOTBRANCHROWIDPOINTERDATASEGMENT0000020234000000020232023249930003001400149995000700090005000599970007200810090009999ROWID|1/4” Rolled Sheet|100 Feet|5 Days|.LEAFCopyright 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.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.Advantages of Partitionsn Reduce time for data loads and index creationn Increase availability of missioncritical databasesn Create partition independencel Enable concurrent operations on separate partitionsl Execute queries on partitions ins