更新时间:2024-05-14 GMT+08:00

系统视图

GaussDB数据库兼容了部分Oracle数据库的系统视图,兼容的详细列表如下。

更多系统视图的字段说明信息请参考《开发者指南》中“系统视图”章节。

表1 系统视图支持列表

序号

Oracle数据库

GaussDB数据库

1

ALL_ALL_TABLES

DB_ALL_TABLES

2

ALL_COL_PRIVS

DB_COL_PRIVS

3

ALL_COLL_TYPES

DB_COLL_TYPES

4

ALL_IND_COLUMNS

DB_IND_COLUMNS

5

ALL_COL_COMMENTS

DB_COL_COMMENTS

6

ALL_CONS_COLUMNS

DB_CONS_COLUMNS

7

ALL_CONSTRAINTS

DB_CONSTRAINTS

8

ALL_DEPENDENCIES

DB_DEPENDENCIES

9

ALL_DIRECTORIES

DB_DIRECTORIES

10

ALL_IND_EXPRESSIONS

DB_IND_EXPRESSIONS

11

ALL_IND_PARTITIONS

DB_IND_PARTITIONS

12

ALL_INDEXES

DB_INDEXES

13

ALL_IND_SUBPARTITIONS

DB_IND_SUBPARTITIONS

14

ALL_OBJECTS

DB_OBJECTS

15

ALL_PART_COL_STATISTICS

DB_PART_COL_STATISTICS

16

ALL_PART_KEY_COLUMNS

DB_PART_KEY_COLUMNS

17

ALL_PART_TABLES

DB_PART_TABLES

18

ALL_SCHEDULER_JOB_ARGS

DB_SCHEDULER_JOB_ARGS

19

ALL_SCHEDULER_PROGRAM_ARGS

DB_SCHEDULER_PROGRAM_ARGS

20

ALL_SEQUENCES

DB_SEQUENCES

21

ALL_SUBPART_KEY_COLUMNS

DB_SUBPART_KEY_COLUMNS

22

ALL_SYNONYMS

DB_SYNONYMS

23

ALL_TAB_COL_STATISTICS

DB_TAB_COL_STATISTICS

24

ALL_TAB_COMMENTS

DB_TAB_COMMENTS

25

ALL_TAB_HISTOGRAMS

DB_TAB_HISTOGRAMS

26

ALL_TAB_STATS_HISTORY

DB_TAB_STATS_HISTORY

27

ALL_TYPES

DB_TYPES

28

ALL_PROCEDURES

DB_PROCEDURES

29

ALL_SOURCE

DB_SOURCE

30

ALL_TAB_COLUMNS

DB_TAB_COLUMNS

31

ALL_TAB_PARTITIONS

DB_TAB_PARTITIONS

32

ALL_TAB_SUBPARTITIONS

DB_TAB_SUBPARTITIONS

33

ALL_TABLES

DB_TABLES

34

ALL_TRIGGERS

DB_TRIGGERS

35

ALL_USERS

DB_USERS

36

ALL_VIEWS

DB_VIEWS

37

DBA_AUDIT_OBJECT

ADM_AUDIT_OBJECT

38

DBA_AUDIT_SESSION

ADM_AUDIT_SESSION

39

DBA_AUDIT_STATEMENT

ADM_AUDIT_STATEMENT

40

DBA_AUDIT_TRAIL

ADM_AUDIT_TRAIL

41

DBA_COL_COMMENTS

ADM_COL_COMMENTS

42

DBA_COL_PRIVS

ADM_COL_PRIVS

43

DBA_COLL_TYPES

ADM_COLL_TYPES

44

DBA_ARGUMENTS

ADM_ARGUMENTS

45

DBA_CONSTRAINTS

ADM_CONSTRAINTS

46

DBA_DATA_FILES

ADM_DATA_FILES

47

DBA_CONS_COLUMNS

ADM_CONS_COLUMNS

48

DBA_DEPENDENCIES

ADM_DEPENDENCIES

49

DBA_DIRECTORIES

ADM_DIRECTORIES

50

DBA_PART_COL_STATISTICS

ADM_PART_COL_STATISTICS

51

DBA_PART_TABLES

ADM_PART_TABLES

52

DBA_ROLE_PRIVS

ADM_ROLE_PRIVS

53

DBA_ROLES

ADM_ROLES

54

DBA_SCHEDULER_JOB_ARGS

ADM_SCHEDULER_JOB_ARGS

55

DBA_SCHEDULER_PROGRAMS

ADM_SCHEDULER_PROGRAMS

56

DBA_SCHEDULER_PROGRAM_ARGS

ADM_SCHEDULER_PROGRAM_ARGS

57

DBA_HIST_SNAPSHOT

ADM_HIST_SNAPSHOT

58

DBA_HIST_SQL_PLAN

ADM_HIST_SQL_PLAN

59

DBA_HIST_SQLSTAT

ADM_HIST_SQLSTAT

60

DBA_HIST_SQLTEXT

ADM_HIST_SQLTEXT

61

DBA_ILMDATAMOVEMENTPOLICIES

GS_ADM_ILMDATAMOVEMENTPOLICIES

62

DBA_ILMEVALUATIONDETAILS

GS_ADM_ILMEVALUATIONDETAILS

63

DBA_ILMOBJECTS

GS_ADM_ILMOBJECTS

64

DBA_ILMPARAMETERS

GS_ADM_ILMPARAMETERS

65

DBA_ILMPOLICIES

GS_ADM_ILMPOLICIES

66

DBA_ILMRESULTS

GS_ADM_ILMRESULTS

67

DBA_ILMTASKS

GS_ADM_ILMTASKS

68

DBA_IND_COLUMNS

ADM_IND_COLUMNS

69

DBA_IND_EXPRESSIONS

ADM_IND_EXPRESSIONS

70

DBA_IND_PARTITIONS

ADM_IND_PARTITIONS

71

DBA_INDEXES

ADM_INDEXES

72

DBA_OBJECTS

ADM_OBJECTS

73

DBA_PART_INDEXES

ADM_PART_INDEXES

74

DBA_PROCEDURES

ADM_PROCEDURES

75

DBA_SCHEDULER_JOBS

ADM_SCHEDULER_JOBS

76

DBA_SCHEDULER_RUNNING_JOBS

ADM_SCHEDULER_RUNNING_JOBS

77

DBA_SEGMENTS

ADM_SEGMENTS

78

DBA_SEQUENCES

ADM_SEQUENCES

79

DBA_SOURCE

ADM_SOURCE

80

DBA_IND_SUBPARTITIONS

ADM_IND_SUBPARTITIONS

81

DBA_SUBPART_KEY_COLUMNS

ADM_SUBPART_KEY_COLUMNS

82

DBA_SYS_PRIVS

ADM_SYS_PRIVS

83

DBA_TAB_COL_STATISTICS

ADM_TAB_COL_STATISTICS

84

DBA_TAB_HISTOGRAMS

ADM_TAB_HISTOGRAMS

85

DBA_TAB_STATISTICS

ADM_TAB_STATISTICS

86

DBA_TAB_STATS_HISTORY

ADM_TAB_STATS_HISTORY

87

DBA_TABLESPACES

ADM_TABLESPACES

88

DBA_TYPES

ADM_TYPES

89

DBA_USERS

ADM_USERS

90

DBA_SYNONYMS

ADM_SYNONYMS

91

DBA_TAB_COLS

ADM_TAB_COLS

92

DBA_TAB_COLUMNS

ADM_TAB_COLUMNS

93

DBA_TAB_COMMENTS

ADM_TAB_COMMENTS

94

DBA_TABLES

ADM_TABLES

95

DBA_TAB_PARTITIONS

ADM_TAB_PARTITIONS

96

DBA_TAB_SUBPARTITIONS

ADM_TAB_SUBPARTITIONS

97

DBA_TRIGGERS

ADM_TRIGGERS

98

DBA_TYPE_ATTRS

ADM_TYPE_ATTRS

99

DBA_VIEWS

ADM_VIEWS

100

ROLE_ROLE_PRIVS

ROLE_ROLE_PRIVS

101

ROLE_SYS_PRIVS

ROLE_SYS_PRIVS

102

ROLE_TAB_PRIVS

ROLE_TAB_PRIVS

103

USER_COL_COMMENTS

MY_COL_COMMENTS

104

USER_COL_PRIVS

MY_COL_PRIVS

105

USER_COLL_TYPES

MY_COLL_TYPES

106

USER_CONSTRAINTS

MY_CONSTRAINTS

107

USER_DEPENDENCIES

MY_DEPENDENCIES

108

DICT

DICT

109

DICTIONARY

DICTIONARY

110

DUAL

DUAL

111

NLS_DATABASE_PARAMETERS

NLS_DATABASE_PARAMETERS

112

NLS_INSTANCE_PARAMETERS

NLS_INSTANCE_PARAMETERS

113

PLAN_TABLE

PLAN_TABLE

114

USER_ILMDATAMOVEMENTPOLICIES

GS_MY_ILMDATAMOVEMENTPOLICIES

115

USER_ILMEVALUATIONDETAILS

GS_MY_ILMEVALUATIONDETAILS

116

USER_ILMOBJECTS

GS_MY_ILMOBJECTS

117

USER_ILMPOLICIES

GS_MY_ILMPOLICIES

118

USER_ILMRESULTS

GS_MY_ILMRESULTS

119

USER_ILMTASKS

GS_MY_ILMTASKS

120

USER_IND_COLUMNS

MY_IND_COLUMNS

121

USER_IND_EXPRESSIONS

MY_IND_EXPRESSIONS

122

USER_IND_PARTITIONS

MY_IND_PARTITIONS

123

USER_IND_SUBPARTITIONS

MY_IND_SUBPARTITIONS

124

USER_INDEXES

MY_INDEXES

125

USER_JOBS

MY_JOBS

126

USER_OBJECTS

MY_OBJECTS

127

USER_PART_COL_STATISTICS

MY_PART_COL_STATISTICS

128

USER_PART_INDEXES

MY_PART_INDEXES

129

USER_PART_TABLES

MY_PART_TABLES

130

USER_PROCEDURES

MY_PROCEDURES

131

USER_SCHEDULER_JOB_ARGS

MY_SCHEDULER_JOB_ARGS

132

USER_SCHEDULER_PROGRAM_ARGS

MY_SCHEDULER_PROGRAM_ARGS

133

USER_SEQUENCES

MY_SEQUENCES

134

USER_SOURCE

MY_SOURCE

135

USER_SUBPART_KEY_COLUMNS

MY_SUBPART_KEY_COLUMNS

136

USER_SYNONYMS

MY_SYNONYMS

137

USER_SYS_PRIVS

MY_SYS_PRIVS

138

USER_TAB_COL_STATISTICS

MY_TAB_COL_STATISTICS

139

USER_TAB_COLUMNS

MY_TAB_COLUMNS

140

USER_TAB_COMMENTS

MY_TAB_COMMENTS

141

USER_TAB_HISTOGRAMS

MY_TAB_HISTOGRAMS

142

USER_TAB_PARTITIONS

MY_TAB_PARTITIONS

143

USER_TAB_STATISTICS

MY_TAB_STATISTICS

144

USER_TAB_STATS_HISTORY

MY_TAB_STATS_HISTORY

145

USER_TABLES

MY_TABLES

146

USER_TABLESPACES

MY_TABLESPACES

147

USER_TRIGGERS

MY_TRIGGERS

148

USER_TYPE_ATTRS

MY_TYPE_ATTRS

149

USER_TYPES

MY_TYPES

150

USER_VIEWS

MY_VIEWS

151

V$NLS_PARAMETERS

V$NLS_PARAMETERS

152

V$SESSION_WAIT

V$SESSION_WAIT

153

V$SYSSTAT

V$SYSSTAT

154

V$SYSTEM_EVENT

V$SYSTEM_EVENT

155

V$VERSION

V$VERSION

156

V$INSTANCE

V_INSTANCE

157

GV$INSTANCE

GV_INSTANCE

158

V$MYSTAT

V_MYSTAT

159

V$SESSION

V_SESSION

160

GV$SESSION

GV_SESSION

161

V$SESSION_LONGOPS

DV_SESSION_LONGOPS

162

V$SESSION

DV_SESSIONS

163

ALL_ARGUMENTS

DB_ARGUMENTS

164

USER_CONS_COLUMNS

MY_CONS_COLUMNS

165

USER_PART_KEY_COLUMNS

MY_PART_KEY_COLUMNS

166

USER_ROLE_PRIVS

MY_ROLE_PRIVS

167

DBA_TAB_PRIVS

ADM_TAB_PRIVS

168

USER_SCHEDULER_JOBS

MY_SCHEDULER_JOBS

169

V$LOCK

V$LOCK

170

V$DBLINK

V$DBLINK

171

V$GLOBAL_TRANSACTION

V$GLOBAL_TRANSACTION

172

V$OPEN_CURSOR

V$OPEN_CURSOR

173

V$GLOBAL_OPEN_CURSOR

V$GLOBAL_OPEN_CURSOR

174

ALL_TAB_PRIVS

DB_TAB_PRIVS

175

ALL_TAB_MODIFICATIONS

DB_TAB_MODIFICATIONS

176

USER_TAB_MODIFICATIONS

MY_TAB_MODIFICATIONS

177

USER_AUDIT_TRAIL

MY_AUDIT_TRAIL