加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MySql教程 > 正文

oracle 查看表属主和表空间sql

发布时间:2020-12-11 23:55:32 所属栏目:MySql教程 来源:网络整理
导读:查看表空间 select * from user_tablespaces?where table_name = 'TableName' 查看表属主 select ? Owner? from all_tab_columns where table_name = 'TableName' 附录: A? tablespace ?is a storage location where the actual data underlying??objects c

查看表空间

select * from user_tablespaces?where table_name = 'TableName'

查看表属主

select ?Owner? from all_tab_columns where table_name = 'TableName'

附录:

A?tablespace?is a storage location where the actual data underlying??objects can be kept. It provides a layer of abstraction between physical and logical data,?and serves to allocate storage for all??managed segments. (A database segment is a database object which occupies physical space such as?data and?.) Once created,a tablespace can be referred to by name when creating database segments.

Tablespaces specify only the database storage locations,not the logical database structure,or?. For instance,different objects in the same schema may have different underlying tablespaces. Similarly,a tablespace may service segments for more than one schema. Sometimes it can be used to specify schema as to form a bond between logical and physical data.

By using tablespaces,an administrator can control the disk layout of an installation. A common use of tablespaces is to optimize performance. For example,a heavily used index can be placed on a fast??. On the other hand,a database table which contains archived data that is rarely accessed could be stored on a less expensive but slower??disk.

While it is common for tablespaces to store their data in a filesystem file,a single file must be part of a single tablespace. Some?allow tablespaces to be configured directly over operating-system device entries,called?,providing better performance by avoiding the OS filesystem overheads.

?stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace.

reference:http://en.wikipedia.org/wiki/Tablespace

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读