Overview of Datafiles (62)
A tablespace in an Oracle database consists of one or more physical datafiles. A
datafile can be associated with only one tablespace and only one database.
Oracle creates a datafile for a tablespace by allocating the specified amount of disk
space plus the overhead required for the file header. When a datafile is created, the
operating system under which Oracle runs is responsible for clearing old information
and authorizations from a file before allocating it to Oracle. If the file is large, this
process can take a significant amount of time. The first tablespace in any database is
always the SYSTEM tablespace, so Oracle automatically allocates the first datafiles of
any database for the SYSTEM tablespace during database creation.[@more@]
datafile can be associated with only one tablespace and only one database.
Oracle creates a datafile for a tablespace by allocating the specified amount of disk
space plus the overhead required for the file header. When a datafile is created, the
operating system under which Oracle runs is responsible for clearing old information
and authorizations from a file before allocating it to Oracle. If the file is large, this
process can take a significant amount of time. The first tablespace in any database is
always the SYSTEM tablespace, so Oracle automatically allocates the first datafiles of
any database for the SYSTEM tablespace during database creation.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-976979/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- alter system check datafiles 命令
- Flutter OverviewFlutterView
- 【Oracle】How to Rename or Move Datafiles and Logfiles 之二Oracle
- 【Oracle】How to Rename or Move Datafiles and Logfiles 之一Oracle
- OMF (Oracle Managed Files) Usage for Datafiles [ID 137482.1]Oracle
- dart class overviewDartView
- Stormstarter-OverviewORMView
- Overview of PartitioningView
- Overview of Database CheckpointsViewDatabase
- Overview of Unix ResourcesView
- oracle function overviewOracleFunctionView
- Item Import OverviewImportView
- Overview of Extents(11)View
- Overview of Partitioned IndexesViewIndex
- Overview of Tablespaces (38)View
- Overview of Views (174)View
- Overview of Segments (22)View
- 高通USB overviewView
- Overview of Availability in a CDBViewAI
- 2.4 Overview of Services in a CDBView
- 7-Overview-namesView
- 8-Overview-NamespacesViewnamespace
- 10-Overview-AnnotationsView
- [英] TensorFlow OverviewView
- Deadlock Overview and DiscussionView
- Overview of Data Blocks(二)ViewBloC
- Overview of Clusters (238)View
- Overview of Tables (154)View
- Overview of Dimensions (191)View
- Overview of Synonyms (193)View
- Overview of Indexes (194)ViewIndex
- Using FTP Transferring Non-ASM Datafiles to ASM diskgroupFTPASM
- 62. 不同路徑
- HDU 不要62 題解
- Step-By-Step Installation of RAC with RAW Datafiles on Windows 2000Windows
- 2.6.2 Overview of Flashback PDB in a CDBView
- 2.2.7 Overview of PDB Lockdown ProfilesView
- An Overview of PostgreSQL & MySQL Cross ReplicationViewMySqlROS