资源描述：
《Oracle对象定义英文版).ppt》由会员上传分享，免费在线阅读，更多相关内容在PPT专区-天天文库。
1、DefineDatabaseObjectsCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsOBJECTIVESDefineTablespacesDefineTablesandIndexesDefineSegments,Extents,andBlocksCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsOverviewDatabaseTables
2、paceTables,indexes,etc.DatafilesSegmentExtentBlocksCopyright©2001GlobalBusinessSolutions,Inc.TablespacesLargestlogicalunitofspaceConsistofoneormoredatafilesSYSTEMtablespacemustexistTablespaceCopyright©2001GlobalBusinessSolutions,Inc.TypesofTablespace
3、sSystem/NonsystemOnline/OfflineRead-Write/Read-OnlyTransportableCopyright©2001GlobalBusinessSolutions,Inc.SystemandNonsystemTablespacesSystemAtleastoneDataDictionaryRollbackNonsystemFacilitatesAdministrationUser/ApplicationData,IndexesRollbackandTemp
4、orarySegmentsCopyright©2001GlobalBusinessSolutions,Inc.OnlineandOfflineTablespacesOnlineAvailabletoapplicationsTypicallytablespacesonlineOfflineNotavailabletousers,evenifdatabaseisavailableUseformaintenance,troubleshooting,orhistoricaldatanolongernee
5、dedOnlineOfflineCopyright©2001GlobalBusinessSolutions,Inc.Read-WriteandRead-OnlyTablespacesRead-WriteCreate,alter,anddropdatabaseobjectsDefaultRead-OnlyCannotcreateoralterdatabaseobjectsCandropcertainobjectsCanresideonWormdeviceorCDROMEliminateredund
6、antdatabackupsIdealforDataWarehouseapplicationsandLookuptablesRead-WriteRead-OnlyCopyright©2001GlobalBusinessSolutions,Inc.TipsforRead-OnlyTablespacesOrganizebymodificationrequirementsFrequencyofdatachangeBackuprequirementSecurityrequirementUserrequi
7、rementAssociateddatafilecannotbe:ResizedorhaveautoextendsettoonRenamedtoanewdatafilenameordirectoryOfflineCopyright©2001GlobalBusinessSolutions,Inc.TransportableTablespacesSystemTablespaceTransportableTablespaceSystemTablespaceExportImportCopyUtility
8、TransportableTablespaceSourceDatabaseTargetDatabaseCopyright©2001GlobalBusinessSolutions,Inc.UsesofTransportableTablespacesArchiveOLTPanddatawarehousesystemsTransferdatafromOLTPtodatawarehousestagingsystemsLoadingdatamartsfromcentraldatawarehousesPub
