oracle對象定義(英文版)-展示頁
2025-02-11 07:35本頁面
【正文】 ldsCopyright 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.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.Types of Tablespacesn System/Nonsystemn Online/Offlinen ReadWrite/ReadOnlyn TransportableCopyright 169。 2023 Global Business Solutions, Inc.Define Database Objects OverviewDatabaseTablespaceTables, indexes, etc. DatafilesSegmentExtentBlocksCopyright 169。Define Database ObjectsCopyright 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.Tablespacesn Largest logical unit of spacen Consist of one or more datafilesn SYSTEM tablespace must existTablespaceCopyright 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.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 Solutions, Inc.Transportable TablespacesSystem TablespaceTransportable TablespaceSystem Tablespace ExportImportCopyUtilityTransportable TablespaceSource DatabaseTarget DatabaseCopyright 169。 2023 Global Business Solutions, Inc.Tablesn Stored in Tablespacesn Organized in rows and columnsn Contain dataTablespaceTables, indexes, etc.DatafilesSegmentExtentBlocksCopyright 169。 2023 Global Business Solutions, Inc.Large Object Datatypen Store Unstructured Informationl Text documentsl Static imagesl Videol AudioCustomersNa
試題試卷相關(guān)推薦
鄂ICP備17016276號-1