Chapter 50. 系统目录

Table of Contents

50.1. 概述
50.2. lt_attri_ext
50.3. lt_database_ext
50.4. lt_global_temp_table_ext
50.5. lt_object_ext
50.6. lt_package
50.7. lt_partition_ext
50.8. lt_proc_ext
50.9. lt_trigger_ext
50.10. lt_recyclebin
50.11. lt_type_ext
50.12. lt_variable
50.13. lt_namespace_ext
50.14. pg_aggregate
50.15. pg_am
50.16. pg_amop
50.17. pg_amproc
50.18. pg_attrdef
50.19. pg_attribute
50.20. pg_authid
50.21. pg_auth_members
50.22. pg_cast
50.23. pg_class
50.24. pg_collation
50.25. pg_constraint
50.26. pg_conversion
50.27. pg_database
50.28. pg_db_role_setting
50.29. pg_default_acl
50.30. pg_depend
50.31. pg_description
50.32. pg_enum
50.33. pg_event_trigger
50.34. pg_extension
50.35. pg_foreign_data_wrapper
50.36. pg_foreign_server
50.37. pg_foreign_table
50.38. pg_index
50.39. pg_inherits
50.40. pg_init_privs
50.41. pg_language
50.42. pg_largeobject
50.43. pg_largeobject_metadata
50.44. pg_namespace
50.45. pg_opclass
50.46. pg_operator
50.47. pg_opfamily
50.48. pg_partitioned_table
50.49. pg_policy
50.50. pg_proc
50.51. pg_publication
50.52. pg_publication_rel
50.53. pg_range
50.54. pg_replication_origin
50.55. pg_rewrite
50.56. pg_seclabel
50.57. pg_sequence
50.58. pg_shdepend
50.59. pg_shdescription
50.60. pg_shseclabel
50.61. pg_statistic
50.62. pg_statistic_ext
50.63. pg_statistic_ext_data
50.64. pg_subscription
50.65. pg_subscription_rel
50.66. pg_tablespace
50.67. pg_trigger
50.68. pg_ts_config
50.69. pg_ts_config_map
50.70. pg_ts_dict
50.71. pg_ts_parser
50.72. pg_ts_template
50.73. pg_type
50.74. pg_user_mapping
50.75. 系统视图
50.76. pg_available_extensions
50.77. pg_available_extension_versions
50.78. pg_config
50.79. pg_cursors
50.80. pg_file_settings
50.81. pg_group
50.82. pg_hba_file_rules
50.83. pg_indexes
50.84. pg_locks
50.85. pg_policies
50.86. pg_prepared_statements
50.87. pg_prepared_xacts
50.88. pg_publication_tables
50.89. pg_replication_origin_status
50.90. pg_replication_slots
50.91. pg_roles
50.92. pg_rules
50.93. pg_seclabels
50.94. pg_sequences
50.95. pg_settings
50.96. pg_shadow
50.97. pg_shmem_allocations
50.98. pg_stats
50.99. pg_stats_ext
50.100. pg_tables
50.101. pg_timezone_abbrevs
50.102. pg_timezone_names
50.103. pg_user
50.104. pg_user_mappings
50.105. pg_views
50.106. oracle兼容系统视图
50.106.1. [DBA/ALL/USER]_SEQUENCES
50.106.2. [DBA/ALL/USER]_SYNONYMS
50.106.3. [DBA/ALL/USER]_TAB_COLS, COLS, [DBA/ALL/USER]_TAB_COLUMNS
50.106.4. [DBA/ALL/USER]_TAB_COL_STATISTICS
50.106.5. [DBA/ALL/USER]_OBJECTS, OBJ
50.106.6. [DBA/ALL/USER]_CATALOG
50.106.7. DICTIONARY, DICT
50.106.8. [DBA/ALL/USER]_DEPENDENCIES
50.106.9. [DBA/ALL/USER]_SOURCE
50.106.10. [DBA/ALL/USER]_PROCEDURES
50.106.11. [DBA/ALL/USER]_TRIGGERS
50.106.12. [DBA/ALL/USER]_TRIGGER_COLS
50.106.13. [DBA/ALL/USER]_TYPES
50.106.14. [DBA/ALL/USER]_CONSTRAINTS
50.106.15. [DBA/ALL/USER]_CONS_COLUMNS
50.106.16. [DBA/ALL/USER]_VIEWS
50.106.17. [DBA/ALL/USER]_TABLES, [DBA/ALL/USER]_ALL_TABLES, TAB
50.106.18. [DBA/ALL/USER]_TAB_STATISTICS
50.106.19. [DBA/ALL/USER]_TAB_COMMENTS
50.106.20. [DBA/ALL/USER]_COL_COMMENTS
50.106.21. [DBA/ALL/USER]_TAB_MODIFICATIONS
50.106.22. [DBA/ALL/USER]_INDEXES, IND
50.106.23. [DBA/ALL/USER]_INDEX_USAGE
50.106.24. [DBA/ALL/USER]_IND_COLUMNS
50.106.25. [DBA/ALL/USER]_IND_EXPRESSIONS
50.106.26. [DBA/ALL/USER]_IND_STATISTICS
50.106.27. [DBA/ALL/USER]_USERS
50.106.28. DBA_ROLES
50.106.29. [DBA/USER]_ROLE_PRIVS
50.106.30. PRODUCT_COMPONENT_VERSION
50.106.31. PLAN_TABLE
50.106.32. DBA_DATA_FILES
50.106.33. [DBA/ALL/USER]_JOBS
50.106.34. DBA_JOBS_RUNNING
50.106.35. [DBA/USER]_TABLESPACES
50.106.36. NLS_[DATABASE/INSTANCE/SESSION]_PARAMETERS
50.106.37. [DBA/USER]_SEGMENTS
50.106.38. [DBA/USER/ALL]_PART_TABLES
50.106.39. [DBA/USER/ALL]_TAB_PARTITIONS
50.106.40. [DBA/USER/ALL]_TAB_SUBPARTITIONS
50.106.41. [DBA/USER/ALL]_PART_KEY_COLUMNS
50.106.42. [DBA/USER/ALL]_SUBPART_KEY_COLUMNS
50.106.43. [DBA/USER/ALL]_IND_PARTITIONS
50.106.44. [DBA/USER/ALL]_PART_INDEXES
50.106.45. COL
50.106.46. [DBA/USER]_RECYCLEBIN

系统目录是关系型数据库存放模式元数据的地方,比如表和列的信息,以及内部统计信息等。LightDB的系统目录就是普通表。你可以删除并重建这些表、增加列、插入和更新数值, 然后彻底把你的系统搞垮。 通常情况下,我们不应该手工修改系统目录,通常有SQL命令可以做这些事情。(例如,CREATE DATABASEpg_database表插入一行 — 并且实际上在磁盘上创建该数据库。)。 有几种特别深奥的操作例外,但是随着时间的流逝其中的很多也可以用 SQL 命令来完成,因此对系统目录直接修改的需求也越来越小。