Chapter 47. 系统目录

Table of Contents

47.1. 概述
47.2. lt_attri_ext
47.3. lt_database_ext
47.4. lt_global_temp_table_ext
47.5. lt_object_ext
47.6. lt_package
47.7. lt_partition_ext
47.8. lt_proc_ext
47.9. lt_trigger_ext
47.10. lt_recyclebin
47.11. lt_type_ext
47.12. lt_variable
47.13. lt_namespace_ext
47.14. pg_aggregate
47.15. pg_am
47.16. pg_amop
47.17. pg_amproc
47.18. pg_attrdef
47.19. pg_attribute
47.20. pg_authid
47.21. pg_auth_members
47.22. pg_cast
47.23. pg_class
47.24. pg_collation
47.25. pg_constraint
47.26. pg_conversion
47.27. pg_database
47.28. pg_db_role_setting
47.29. pg_default_acl
47.30. pg_depend
47.31. pg_description
47.32. pg_enum
47.33. pg_event_trigger
47.34. pg_extension
47.35. pg_foreign_data_wrapper
47.36. pg_foreign_server
47.37. pg_foreign_table
47.38. pg_index
47.39. pg_inherits
47.40. pg_init_privs
47.41. pg_language
47.42. pg_largeobject
47.43. pg_largeobject_metadata
47.44. pg_namespace
47.45. pg_opclass
47.46. pg_operator
47.47. pg_opfamily
47.48. pg_partitioned_table
47.49. pg_policy
47.50. pg_proc
47.51. pg_publication
47.52. pg_publication_rel
47.53. pg_range
47.54. pg_replication_origin
47.55. pg_rewrite
47.56. pg_seclabel
47.57. pg_sequence
47.58. pg_shdepend
47.59. pg_shdescription
47.60. pg_shseclabel
47.61. pg_statistic
47.62. pg_statistic_ext
47.63. pg_statistic_ext_data
47.64. pg_subscription
47.65. pg_subscription_rel
47.66. pg_tablespace
47.67. pg_transform
47.68. pg_trigger
47.69. pg_ts_config
47.70. pg_ts_config_map
47.71. pg_ts_dict
47.72. pg_ts_parser
47.73. pg_ts_template
47.74. pg_type
47.75. pg_user_mapping
47.76. 系统视图
47.77. pg_available_extensions
47.78. pg_available_extension_versions
47.79. pg_config
47.80. pg_cursors
47.81. pg_file_settings
47.82. pg_group
47.83. pg_hba_file_rules
47.84. pg_indexes
47.85. pg_locks
47.86. pg_matviews
47.87. pg_policies
47.88. pg_prepared_statements
47.89. pg_prepared_xacts
47.90. pg_publication_tables
47.91. pg_replication_origin_status
47.92. pg_replication_slots
47.93. pg_roles
47.94. pg_rules
47.95. pg_seclabels
47.96. pg_sequences
47.97. pg_settings
47.98. pg_shadow
47.99. pg_shmem_allocations
47.100. pg_stats
47.101. pg_stats_ext
47.102. pg_tables
47.103. pg_timezone_abbrevs
47.104. pg_timezone_names
47.105. pg_user
47.106. pg_user_mappings
47.107. pg_views
47.108. oracle兼容系统视图
47.108.1. [DBA/ALL/USER]_SEQUENCES
47.108.2. [DBA/ALL/USER]_SYNONYMS
47.108.3. [DBA/ALL/USER]_TAB_COLS, COLS, [DBA/ALL/USER]_TAB_COLUMNS
47.108.4. [DBA/ALL/USER]_TAB_COL_STATISTICS
47.108.5. [DBA/ALL/USER]_OBJECTS, OBJ
47.108.6. [DBA/ALL/USER]_CATALOG
47.108.7. DICTIONARY, DICT
47.108.8. [DBA/ALL/USER]_DEPENDENCIES
47.108.9. [DBA/ALL/USER]_SOURCE
47.108.10. [DBA/ALL/USER]_PROCEDURES
47.108.11. [DBA/ALL/USER]_TRIGGERS
47.108.12. [DBA/ALL/USER]_TRIGGER_COLS
47.108.13. [DBA/ALL/USER]_TYPES
47.108.14. [DBA/ALL/USER]_CONSTRAINTS
47.108.15. [DBA/ALL/USER]_CONS_COLUMNS
47.108.16. [DBA/ALL/USER]_VIEWS
47.108.17. [DBA/ALL/USER]_TABLES, [DBA/ALL/USER]_ALL_TABLES, TAB
47.108.18. [DBA/ALL/USER]_TAB_STATISTICS
47.108.19. [DBA/ALL/USER]_TAB_COMMENTS
47.108.20. [DBA/ALL/USER]_COL_COMMENTS
47.108.21. [DBA/ALL/USER]_TAB_MODIFICATIONS
47.108.22. [DBA/ALL/USER]_INDEXES, IND
47.108.23. [DBA/ALL/USER]_INDEX_USAGE
47.108.24. [DBA/ALL/USER]_IND_COLUMNS
47.108.25. [DBA/ALL/USER]_IND_EXPRESSIONS
47.108.26. [DBA/ALL/USER]_IND_STATISTICS
47.108.27. [DBA/ALL/USER]_USERS
47.108.28. DBA_ROLES
47.108.29. [DBA/USER]_ROLE_PRIVS
47.108.30. PRODUCT_COMPONENT_VERSION
47.108.31. PLAN_TABLE
47.108.32. DBA_DATA_FILES
47.108.33. [DBA/ALL/USER]_JOBS
47.108.34. DBA_JOBS_RUNNING
47.108.35. [DBA/ALL/USER]_MVIEWS
47.108.36. [DBA/ALL/USER]_MVIEW_LOGS
47.108.37. [DBA/ALL/USER]_MVIEW_COMMENTS
47.108.38. [DBA/USER]_TABLESPACES
47.108.39. NLS_[DATABASE/INSTANCE/SESSION]_PARAMETERS
47.108.40. [DBA/USER]_SEGMENTS
47.108.41. [DBA/USER/ALL]_PART_TABLES
47.108.42. [DBA/USER/ALL]_TAB_PARTITIONS
47.108.43. [DBA/USER/ALL]_TAB_SUBPARTITIONS
47.108.44. [DBA/USER/ALL]_PART_KEY_COLUMNS
47.108.45. [DBA/USER/ALL]_SUBPART_KEY_COLUMNS
47.108.46. [DBA/USER/ALL]_IND_PARTITIONS
47.108.47. [DBA/USER/ALL]_PART_INDEXES
47.108.48. COL
47.108.49. [DBA/USER]_RECYCLEBIN

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