Oracle体系结构之Oracle基本数据字典:v$database、v$instance、v$version、dba_objects,v$database:视图结构:SQL>descv$database;NameNull?TypeDBIDNUMBERNAMEVARCHAR2(9)CREATEDDATERESETLOGS_CHANGE#NUMBERRESETLOGS_TIMEDATEPRIOR_R
DATABASE_ROLE VARCHAR2(16) ARCHIVELOG_CHANGE# NUMBER ARCHIVELOG_COMPRESSION VARCHAR2(8) SWITCHOVER_STATUS VARCHAR2(20) DATAGUARD_BROKER VARCHAR2(8) GUARD_STATUS VARCHAR2(7) SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(8) SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3) SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3) FORCE_...
A table is a unit of data storage in an Oracle database, containing rows and columns. When you view a table in Object Browser, a table description appears that describes each column in the table. See Also: "Managing Tables" in Oracle Database Express Edition 2 Day Developer Guide Oracle...
Oracle Database recognizes objects that are associated with a particular schema and objects that are not associated with a particular schema, as described in the sections that follow.Schema Objects A schema is a collection of logical structures of data, or schema objects. A schema is owned by...
Manipulating Database Objects Using Oracle Application Express 5.0 Before You Begin Creating a Table from a Spreadsheet Adding a Master Table Modifying a Table Adding a Table Using a Script Adding a Constraint Summary Want to Learn More? Credits...
Oracle Database uses adata segmentin atablespaceto hold table data. Oracle数据库使用表空间中的数据段保存表数据。 As explained in"User Segments", asegmentcontainsextentsmade up ofdata blocks. 如"用户段"所述,段包含由数据块组成的扩展盘区。
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Information in this document applies to any platform. Symptoms The following message is produced in the Alert Log file:performing DML/DDL operation over object in bin.performing DML/DDL operation over objec...
Oracle Database Exadata Cloud Machine - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and laterInformation in this document applies to any platform....
该视图仅适用于 OceanBase 数据库 Oracle 模式。字段说明字段名称类型是否可以为 NULL描述 OBJECT_NAME VARCHAR2(128) NO 对象名字 SUBOBJECT_NAME VARCHAR2(128) NO 子对象名字(例如,partition) OBJECT_ID NUMBER NO 对象的字典 ID 值 DATA_OBJECT_ID NUMBER NO 包含该对象 segment 的字典 ID 值 OBJECT_TYPE ...
PolarDB PostgreSQL版(兼容Oracle)中授予 EXECUTE 特权的语法与 Oracle 数据库并不完全兼容。PolarDB PostgreSQL版(兼容Oracle)需要使用以下关键字之一限定程序名称:FUNCTION、PROCEDURE 或PACKAGE;而在 Oracle 中,必须省略这些关键字。对于函数,PolarDB PostgreSQL版(兼容Oracle)需要在函数名称后包括所有输入(IN、IN OUT)参数...