Oracle下绝对文件号和相对文件号区别

Linux大全评论719 views阅读模式

一:Oracle官方给出的描述
 
Oracle Database assigns each datafile two associated file numbers, an absolute file

number and a relative file number, that are used to uniquely identify it
 
 
Absolute:Uniquely identifies a datafile in the database. This file number can be used in many SQL statements that reference datafiles in place of using the file name. The absolute file number can be found in the FILE# column of the V$DATAFILE or V$TEMPFILE view, or in the FILE_ID column of the DBA_DATA_FILES or DBA_TEMP_FILES  view
 
 
Relative:Uniquely identifies a datafile within a tablespace. For small and medium size databases, relative file numbers usually have the same value as the absolute file number. However, when the

企鹅博客
  • 本文由 发表于 2019年9月16日 14:10:38
  • 转载请务必保留本文链接:https://www.qieseo.com/186778.html

发表评论