Oracle 10g 学习笔记

oracle10g的系统视图(sys、system) 编号 VIEW_NAME 1 ALL_ALL_TABLES 2 ALL_APPLY 3 ALL_APPLY_CONFLICT_COLUMNS 4 ALL_APPLY_DML_HANDLERS 5 ALL_APPLY_ENQUEUE 6 ALL_APPLY_ERROR 7 ALL_APPLY_EXECUTE 8 ALL_APPLY_KEY_COLUMNS 9 ALL_APPLY_PARAMETERS 10 ALL_APPLY_PROGRESS 11 ALL_APPLY_TABLE_COLUMNS 12 ALL_ARGUMENTS 13 ALL_ASSOCIATIONS 14 ALL_AUDIT_POLICIES 15 ALL_AUDIT_POLICY_COLUMNS 16 ALL_AWS 17 ALL_AW_AC 18 ALL_AW_AC_10G 19 ALL_AW_OBJ 20 ALL_AW_PROP 21 ALL_AW_PROP_NAME 22 ALL_AW_PS 23 ALL_BASE_TABLE_MVIEWS 24 ALL_CAPTURE 25 ALL_CAPTURE_EXTRA_ATTRIBUTES 26 ALL_CAPTURE_PARAMETERS 27 ALL_CAPTURE_PREPARED_DATABASE 28 ALL_CAPTURE_PREPARED_SCHEMAS 29 ALL_CAPTURE_PREPARED_TABLES 30 ALL_CATALOG 31 ALL_CLUSTERS 32 ALL_CLUSTER_HASH_EXPRESSIONS 33 ALL_COLL_TYPES 34 ALL_COL_COMMENTS 35 ALL_COL_PRIVS 36 ALL_COL_PRIVS_MADE 37 ALL_COL_PRIVS_RECD 38 ALL_CONSTRAINTS 39 ALL_CONS_COLUMNS 40 ALL_CONS_OBJ_COLUMNS 41 ALL_CONTEXT 42 ALL_DB_LINKS 43 ALL_DEF_AUDIT_OPTS 44 ALL_DEPENDENCIES 45 ALL_DEQUEUE_QUEUES 46 ALL_DIMENSIONS 47 ALL_DIM_ATTRIBUTES 48 ALL_DIM_CHILD_OF 49 ALL_DIM_HIERARCHIES 50 ALL_DIM_JOIN_KEY 51 ALL_DIM_LEVELS 52 ALL_DIM_LEVEL_KEY 53 ALL_DIRECTORIES 54 ALL_ENCRYPTED_COLUMNS 55 ALL_ERRORS 56 ALL_EVALUATION_CONTEXTS 57 ALL_EVALUATION_CONTEXT_TABLES 58 ALL_EVALUATION_CONTEXT_VARS 59 ALL_EXTERNAL_LOCATIONS 60 ALL_EXTERNAL_TABLES 61 ALL_FILE_GROUPS 62 ALL_FILE_GROUP_EXPORT_INFO 63 ALL_FILE_GROUP_FILES 64 ALL_FILE_GROUP_TABLES 65 ALL_FILE_GROUP_TABLESPACES 66 ALL_FILE_GROUP_VERSIONS 67 ALL_INDEXES 68 ALL_INDEXTYPES 69 ALL_INDEXTYPE_ARRAYTYPES 70 ALL_INDEXTYPE_COMMENTS 71 ALL_INDEXTYPE_OPERATORS 72 ALL_IND_COLUMNS 73 ALL_IND_EXPRESSIONS 74 ALL_IND_PARTITIONS 75 ALL_IND_STATISTICS 76 ALL_IND_SUBPARTITIONS 77 ALL_INTERNAL_TRIGGERS 78 ALL_JAVA_ARGUMENTS 79 ALL_JAVA_CLASSES 80 ALL_JAVA_DERIVATIONS 81 ALL_JAVA_FIELDS 82 ALL_JAVA_IMPLEMENTS 83 ALL_JAVA_INNERS 84 ALL_JAVA_LAYOUTS 85 ALL_JAVA_METHODS 86 ALL_JAVA_NCOMPS 87 ALL_JAVA_RESOLVERS 88 ALL_JAVA_THROWS 89 ALL_JOIN_IND_COLUMNS 90 ALL_LIBRARIES 91 ALL_LOBS 92 ALL_LOB_PARTITIONS 93 ALL_LOB_SUBPARTITIONS 94 ALL_LOB_TEMPLATES 95 ALL_LOG_GROUPS 96 ALL_LOG_GROUP_COLUMNS 97 ALL_METHOD_PARAMS 98 ALL_METHOD_RESULTS 99 ALL_MVIEWS 100 ALL_MVIEW_AGGREGATES 101 ALL_MVIEW_ANALYSIS 102 ALL_MVIEW_COMMENTS 103 ALL_MVIEW_DETAIL_RELATIONS 104 ALL_MVIEW_JOINS 105 ALL_MVIEW_KEYS 106 ALL_MVIEW_LOGS 107 ALL_MVIEW_REFRESH_TIMES 108 ALL_NESTED_TABLES 109 ALL_NESTED_TABLE_COLS 110 ALL_OBJECTS 111 ALL_OBJECT_TABLES 112 ALL_OBJ_COLATTRS 113 ALL_OPANCILLARY 114 ALL_OPARGUMENTS 115 ALL_OPBINDINGS 116 ALL_OPERATORS 117 ALL_OPERATOR_COMMENTS 118 ALL_PARTIAL_DROP_TABS 119 ALL_PART_COL_STATISTICS 120 ALL_PART_HISTOGRAMS 121 ALL_PART_INDEXES 122 ALL_PART_KEY_COLUMNS 123 ALL_PART_LOBS 124 ALL_PART_TABLES 125 ALL_PENDING_CONV_TABLES 126 ALL_PLSQL_OBJECT_SETTINGS 127 ALL_POLICIES 128 ALL_POLICY_CONTEXTS 129 ALL_POLICY_GROUPS 130 ALL_PROBE_OBJECTS 131 ALL_PROCEDURES 132 ALL_PROPAGATION 133 ALL_PUBLISHED_COLUMNS 134 ALL_QUEUES 135 ALL_QUEUE_PUBLISHERS 136 ALL_QUEUE_SUBSCRIBERS 137 ALL_QUEUE_TABLES 138 ALL_REFRESH 139 ALL_REFRESH_CHILDREN 140 ALL_REFRESH_DEPENDENCIES 141 ALL_REFS 142 ALL_REGISTERED_MVIEWS 143 ALL_REGISTERED_SNAPSHOTS 144 ALL_REGISTRY_BANNERS 145 ALL_REPAUDIT_ATTRIBUTE 146 ALL_REPAUDIT_COLUMN 147 ALL_REPCAT 148 ALL_REPCATLOG 149 ALL_REPCAT_REFRESH_TEMPLATES 150 ALL_REPCAT_TEMPLATE_OBJECTS 151 ALL_REPCAT_TEMPLATE_PARMS 152 ALL_REPCAT_TEMPLATE_SITES 153 ALL_REPCAT_USER_AUTHORIZATIONS 154 ALL_REPCAT_USER_PARM_VALUES 155 ALL_REPCOLUMN 156 ALL_REPCOLUMN_GROUP 157 ALL_REPCONFLICT 158 ALL_REPDDL 159 ALL_REPFLAVORS 160 ALL_REPFLAVOR_COLUMNS 161 ALL_REPFLAVOR_OBJECTS 162 ALL_REPGENERATED 163 ALL_REPGENOBJECTS 164 ALL_REPGROUP 165 ALL_REPGROUPED_COLUMN 166 ALL_REPGROUP_PRIVILEGES 167 ALL_REPKEY_COLUMNS 168 ALL_REPOBJECT 169 ALL_REPPARAMETER_COLUMN 170 ALL_REPPRIORITY 171 ALL_REPPRIORITY_GROUP 172 ALL_REPPROP 173 ALL_REPRESOLUTION 174 ALL_REPRESOLUTION_METHOD 175 ALL_REPRESOLUTION_STATISTICS 176 ALL_REPRESOL_STATS_CONTROL 177 ALL_REPSCHEMA 178 ALL_REPSITES 179 ALL_REWRITE_EQUIVALENCES 180 ALL_RULES 181 ALL_RULESETS 182 ALL_RULE_SETS 183 ALL_RULE_SET_RULES 184 ALL_SCHEDULER_CHAINS 185 ALL_SCHEDULER_CHAIN_RULES 186 ALL_SCHEDULER_CHAIN_STEPS 187 ALL_SCHEDULER_GLOBAL_ATTRIBUTE 188 ALL_SCHEDULER_JOBS 189 ALL_SCHEDULER_JOB_ARGS 190 ALL_SCHEDULER_JOB_CLASSES 191 ALL_SCHEDULER_JOB_LOG 192 ALL_SCHEDULER_JOB_RUN_DETAILS 193 ALL_SCHEDULER_PROGRAMS 194 ALL_SCHEDULER_PROGRAM_ARGS 195 ALL_SCHEDULER_RUNNING_CHAINS 196 ALL_SCHEDULER_RUNNING_JOBS 197 ALL_SCHEDULER_SCHEDULES 198 ALL_SCHEDULER_WINDOWS 199 ALL_SCHEDULER_WINDOW_DETAILS 200 ALL_SCHEDULER_WINDOW_GROUPS 201 ALL_SCHEDULER_WINDOW_LOG 202 ALL_SCHEDULER_WINGROUP_MEMBERS 203 ALL_SECONDARY_OBJECTS 204 ALL_SEC_RELEVANT_COLS 205 ALL_SEQUENCES 206 ALL_SERVICES 207 ALL_SNAPSHOTS 208 ALL_SNAPSHOT_LOGS 209 ALL_SOURCE 210 ALL_SOURCE_TABLES 211 ALL_SQLJ_TYPES 212 ALL_SQLJ_TYPE_ATTRS 213 ALL_SQLJ_TYPE_METHODS 214 ALL_SQLSET 215 ALL_SQLSET_BINDS 216 ALL_SQLSET_PLANS 217 ALL_SQLSET_REFERENCES 218 ALL_SQLSET_STATEMENTS 219 ALL_STORED_SETTINGS 220 ALL_STREAMS_GLOBAL_RULES 221 ALL_STREAMS_MESSAGE_CONSUMERS 222 ALL_STREAMS_MESSAGE_RULES 223 ALL_STREAMS_NEWLY_SUPPORTED 224 ALL_STREAMS_RULES 225 ALL_STREAMS_SCHEMA_RULES 226 ALL_STREAMS_TABLE_RULES 227 ALL_STREAMS_TRANSFORM_FUNCTION 228 ALL_STREAMS_UNSUPPORTED 229 ALL_SUBPARTITION_TEMPLATES 230 ALL_SUBPART_COL_STATISTICS 231 ALL_SUBPART_HISTOGRAMS 232 ALL_SUBPART_KEY_COLUMNS 233 ALL_SUBSCRIBED_COLUMNS 234 ALL_SUBSCRIBED_TABLES 235 ALL_SUBSCRIPTIONS 236 ALL_SUMDELTA 237 ALL_SUMMARIES 238 ALL_SUMMARY_AGGREGATES 239 ALL_SUMMARY_DETAIL_TABLES 240 ALL_SUMMARY_JOINS 241 ALL_SUMMARY_KEYS 242 ALL_SYNONYMS 243 ALL_TABLES 244 ALL_TAB_COLS 245 ALL_TAB_COLUMNS 246 ALL_TAB_COL_STATISTICS 247 ALL_TAB_COMMENTS 248 ALL_TAB_HISTOGRAMS 249 ALL_TAB_MODIFICATIONS 250 ALL_TAB_PARTITIONS 251 ALL_TAB_PRIVS 252 ALL_TAB_PRIVS_MADE 253 ALL_TAB_PRIVS_RECD 254 ALL_TAB_STATISTICS 255 ALL_TAB_STATS_HISTORY 256 ALL_TAB_SUBPARTITIONS 257 ALL_TRIGGERS 258 ALL_TRIGGER_COLS 259 ALL_TYPES 260 ALL_TYPE_ATTRS 261 ALL_TYPE_METHODS 262 ALL_TYPE_VERSIONS 263 ALL_UNUSED_COL_TABS 264 ALL_UPDATABLE_COLUMNS 265 ALL_USERS 266 ALL_USTATS 267 ALL_VARRAYS 268 ALL_VIEWS 269 ALL_WARNING_SETTINGS 270 ALL_WORKSPACES 271 ALL_XML_INDEXES 272 ALL_XML_SCHEMAS 273 ALL_XML_SCHEMAS2 274 ALL_XML_TABLES 275 ALL_XML_TAB_COLS 276 ALL_XML_VIEWS 277 ALL_XML_VIEW_COLS 278 AQ$ALERT_QT 279 AQ$ALERT_QT_R 280 AQ$ALERT_QT_S 281 AQ$AQ$_MEM_MC 282 AQ$AQ$_MEM_MC_S 283 AQ$AQ_EVENT_TABLE 284 AQ$AQ_SRVNTFN_TABLE 285 AQ$DEF$_AQCALL 286 AQ$DEF$_AQERROR 287 AQ$INTERNET_USERS 288 AQ$KUPC$DATAPUMP_QUETAB 289 AQ$KUPC$DATAPUMP_QUETAB_S 290 AQ$SCHEDULER$_EVENT_QTAB 291 AQ$SCHEDULER$_EVENT_QTAB_R 292 AQ$SCHEDULER$_EVENT_QTAB_S 293 AQ$SCHEDULER$_JOBQTAB 294 AQ$SCHEDULER$_JOBQTAB_R 295 AQ$SCHEDULER$_JOBQTAB_S 296 AQ$SYS$SERVICE_METRICS_TAB 297 AQ$SYS$SERVICE_METRICS_TAB_R 298 AQ$SYS$SERVICE_METRICS_TAB_S 299 AQ$_ALERT_QT_F 300 AQ$_AQ$_MEM_MC_F 301 AQ$_AQ_EVENT_TABLE_F 302 AQ$_AQ_SRVNTFN_TABLE_F 303 AQ$_DEF$_AQCALL_F 304 AQ$_DEF$_AQERROR_F 305 AQ$_KUPC$DATAPUMP_QUETAB_F 306 AQ$_SCHEDULER$_EVENT_QTAB_F 307 AQ$_SCHEDULER$_JOBQTAB_F 308 AQ$_SYS$SERVICE_METRICS_TAB_F 309 CATALOG 310 CHANGE_PROPAGATIONS 311 CHANGE_PROPAGATION_SETS 312 CHANGE_SETS 313 CHANGE_SOURCES 314 CHANGE_TABLES 315 CODE_PIECES 316 CODE_SIZE 317 COL 318 COLUMN_PRIVILEGES 319 DATAB