ArcGIS SDE 之sqlplus 连接Oracle中sde用户查看相关信息

原创最新推荐文章于 2026-08-17 15:57:23 发布 2.3k 阅读 AI写同款

收录于

arcgis

土豆羊肉

码龄12年墨衍会员 · AI 创作全网分发

15粉丝33篇原创

关注

网盘链接下载直接复制百度网盘链接即可免登陆下载，速度比起百度网盘来，提升很大立即下载

AI摘要

本文详细介绍在Oracle数据库中使用ArcGIS建立企业级地理数据库的过程，包括sde用户连接、权限查看、表空间信息、对象基本信息及索引信息。涵盖sde用户权限、拥有的表、表空间大小、Schema信息及创建日期等关键内容。

在Oracle数据库中使用arcgis建立好企业级地理数据库之后，会创建一个sde用户。

1.连接sde用户。

我的sde用户密码是sde,localhost/pdborcl.arcgisonline.cn是我的实例。

2查看当前用户的权限。

SQL> select * from session_privs;

PRIVILEGE
----------------------------------------
ALTER SYSTEM
CREATE SESSION
CREATE TABLE
SELECT ANY TABLE
CREATE ANY INDEX
ALTER ANY INDEX
DROP ANY INDEX
CREATE PUBLIC SYNONYM
DROP PUBLIC SYNONYM
CREATE VIEW
CREATE ANY VIEW

PRIVILEGE
----------------------------------------
DROP ANY VIEW
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE ANY TRIGGER
CREATE TYPE
CREATE LIBRARY
CREATE OPERATOR
CREATE INDEXTYPE
ADMINISTER DATABASE TRIGGER
INHERIT ANY PRIVILEGES

已选择 22 行。

一些权限的说明。

CREATE SESSION 连接到Oracle。

CREATE TABLE CREATE TRIGGER 允许建表和触发器

CREATE SEQUENCE 允许建序列

CREATE PROCEDURE 创建存储过程

ADMINISTER DATABASE TRIGGER 管理触发器

3.查看当前用户拥有的表

SQL> select table_name from user_tables;

TABLE_NAME
--------------------------------------------------------------------------------
VERSION
SPATIAL_REFERENCES
GEOMETRY_COLUMNS
LAYERS
METADATA
RASTER_COLUMNS
TABLE_REGISTRY
COLUMN_REGISTRY
STATES
VERSIONS
MVTABLES_MODIFIED

TABLE_NAME
--------------------------------------------------------------------------------
STATE_LINEAGES
LOCATORS
SDE_XML_INDEXES
SDE_XML_INDEX_TAGS
SDE_XML_COLUMNS
INSTANCES
SDE_ARCHIVES
SDE_LAYER_STATS
BRANCHES
BRANCH_TABLES_MODIFIED
MULTIBRANCH_TABLES

TABLE_NAME
--------------------------------------------------------------------------------
TABLES_LAST_EDIT_TIME
LAYER_LOCKS
STATE_LOCKS
TABLE_LOCKS
OBJECT_LOCKS
PROCESS_INFORMATION
SDE_TABLES_MODIFIED
LINEAGES_MODIFIED
SDE_LOGFILE_POOL
DBTUNE
SERVER_CONFIG

TABLE_NAME
--------------------------------------------------------------------------------
ST_COORDINATE_SYSTEMS
ST_SPATIAL_REFERENCES
ST_GEOMETRY_COLUMNS
ST_GEOMETRY_INDEX
ST_UNITS_OF_MEASURE
ST_PARTITION_INDEX
GDB_TABLES_LAST_MODIFIED
GDB_ITEMS
SDE_XML_DOC1
DR$XMLDOCIX1_TX$I
DR$XMLDOCIX1_TX$R

TABLE_NAME
--------------------------------------------------------------------------------
SDE_XML_DOC2
DR$XMLDOCIX2_TX$I
DR$XMLDOCIX2_TX$R
SDE_XML_DOC3
DR$XMLDOCIX3_TX$I
DR$XMLDOCIX3_TX$R
GDB_ITEMRELATIONSHIPS
SDE_XML_DOC4
DR$XMLDOCIX4_TX$I
DR$XMLDOCIX4_TX$R
GDB_ITEMTYPES

TABLE_NAME
--------------------------------------------------------------------------------
GDB_ITEMRELATIONSHIPTYPES
GDB_REPLICALOG
GDB_LOCKS
GDB_CONFLICTS
SDE_LOGFILES
SDE_LOGFILE_DATA
DR$XMLDOCIX1_TX$K
DR$XMLDOCIX1_TX$N
DR$XMLDOCIX2_TX$K
DR$XMLDOCIX2_TX$N
DR$XMLDOCIX3_TX$K

TABLE_NAME
--------------------------------------------------------------------------------
DR$XMLDOCIX3_TX$N
S1_IDX$
DR$XMLDOCIX4_TX$K
DR$XMLDOCIX4_TX$N

已选择 70 行。

4.查看表空间

SQL> select tablespace_name from sys.dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
USERS
EXAMPLE
SDE

已选择 6 行。

查看表空间的大小。

SQL> SELECT DD.TABLESPACE_NAME,
2 　　 ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) "表空间大小(M)"
3 FROM SYS.DBA_DATA_FILES DD
4 GROUP BY DD.TABLESPACE_NAME
5 ;

TABLESPACE_NAME 表空间大小(M)
------------------------------ -------------
SYSAUX 610
SDE 400
USERS 5
EXAMPLE 1280.63
SYSTEM 280

5 Schema和创建日期

一个用户一个Schema

SQL> select username from dba_users;

USERNAME
--------------------------------------------------------------------------------
SDE
BI
PM
IX
SH
OE
HR
SCOTT
ORACLE_OCM
OJVMSYS
SYSKM

USERNAME
--------------------------------------------------------------------------------
XS$NULL
GSMCATUSER
MDDATA
SYSBACKUP
DIP
SYSDG
APEX_PUBLIC_USER
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
GSMUSER
AUDSYS

USERNAME
--------------------------------------------------------------------------------
PDBADMIN
FLOWS_FILES
DVF
MDSYS
ORDSYS
DBSNMP
WMSYS
APEX_040200
APPQOSSYS
GSMADMIN_INTERNAL
ORDDATA

USERNAME
--------------------------------------------------------------------------------
CTXSYS
ANONYMOUS
XDB
ORDPLUGINS
DVSYS
SI_INFORMTN_SCHEMA
OLAPSYS
LBACSYS
OUTLN
SYSTEM
SYS

已选择 44 行。

查询创建日期。

SQL> select instance_id,instance_name,creation_date from instances;

INSTANCE_ID
-----------
INSTANCE_NAME
--------------------------------------------------------------------------------
CREATION_DATE
--------------
0
SDE
30-9月 -19

查询当前用户的对象的基本信息。

SQL> col object_type for a20
SQL> col object_name for a30
SQL> select object_type,object_name,status,created from user_objects;

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE SPATIAL_REFERENCES VALID 30-9月 -19
TABLE VERSION VALID 30-9月 -19
INDEX SPATIAL_REF_PK VALID 30-9月 -19
TABLE GEOMETRY_COLUMNS VALID 30-9月 -19
INDEX GEOCOL_PK VALID 30-9月 -19
TABLE LAYERS VALID 30-9月 -19
INDEX LAYERS_PK VALID 30-9月 -19
INDEX LAYERS_UK VALID 30-9月 -19
TABLE METADATA VALID 30-9月 -19
INDEX METADATA_PK VALID 30-9月 -19
TABLE RASTER_COLUMNS VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX RASCOL_PK VALID 30-9月 -19
INDEX RASCOL_UK VALID 30-9月 -19
TABLE TABLE_REGISTRY VALID 30-9月 -19
INDEX REGISTRY_PK VALID 30-9月 -19
INDEX REGISTRY_UK2 VALID 30-9月 -19
INDEX OWNER_MVV_IX VALID 30-9月 -19
TABLE COLUMN_REGISTRY VALID 30-9月 -19
INDEX COLREGISTRY_PK VALID 30-9月 -19
TABLE STATES VALID 30-9月 -19
INDEX STATES_PK VALID 30-9月 -19
INDEX STATES_CUK VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
SEQUENCE STATE_ID_GENERATOR_NC VALID 30-9月 -19
TABLE VERSIONS VALID 30-9月 -19
INDEX VERSIONS_UK VALID 30-9月 -19
INDEX VERSIONS_UK2 VALID 30-9月 -19
INDEX VER_STATE_IX VALID 30-9月 -19
TABLE MVTABLES_MODIFIED VALID 30-9月 -19
INDEX MVTABLES_MODIFIED_IX VALID 30-9月 -19
TABLE STATE_LINEAGES VALID 30-9月 -19
INDEX LINEAGES_PK VALID 30-9月 -19
INDEX LINEAGE_ID_IDX2 VALID 30-9月 -19
TABLE LOCATORS VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX LOCATORS_PK VALID 30-9月 -19
INDEX LOCATORS_UK VALID 30-9月 -19
TABLE SDE_XML_INDEXES VALID 30-9月 -19
INDEX XML_INDEXES_PK VALID 30-9月 -19
INDEX XML_INDEXES_UK VALID 30-9月 -19
SEQUENCE XML_INDEX_ID_GENERATOR VALID 30-9月 -19
TABLE SDE_XML_INDEX_TAGS VALID 30-9月 -19
INDEX XML_INDEXTAGS_PK VALID 30-9月 -19
SEQUENCE XML_TAG_ID_GENERATOR VALID 30-9月 -19
INDEX XML_INDEXTAGS_IX1 VALID 30-9月 -19
INDEX XML_INDEXTAGS_IX2 VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE SDE_XML_COLUMNS VALID 30-9月 -19
INDEX XML_COLUMNS_PK VALID 30-9月 -19
INDEX XML_COLUMNS_UK VALID 30-9月 -19
SEQUENCE XML_COLUMN_ID_GENERATOR VALID 30-9月 -19
TABLE INSTANCES VALID 30-9月 -19
INDEX INSTANCES_PK VALID 30-9月 -19
INDEX SYS_C0010392 VALID 30-9月 -19
SEQUENCE INSTANCE_ID_GENERATOR VALID 30-9月 -19
TABLE SDE_ARCHIVES VALID 30-9月 -19
INDEX ARCHIVES_PK VALID 30-9月 -19
INDEX ARCHIVES_UK VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE SDE_LAYER_STATS VALID 30-9月 -19
INDEX LAYER_STATS_UK VALID 30-9月 -19
TABLE BRANCHES VALID 30-9月 -19
INDEX BRANCH_PK VALID 30-9月 -19
SEQUENCE ISEQ$$_92853 VALID 30-9月 -19
INDEX BRANCH_UK VALID 30-9月 -19
INDEX BRANCH_SN_IDX VALID 30-9月 -19
INDEX BRANCH_BG_UK VALID 30-9月 -19
TABLE BRANCH_TABLES_MODIFIED VALID 30-9月 -19
INDEX BTM_UK VALID 30-9月 -19
TABLE MULTIBRANCH_TABLES VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX SYS_IL0000092861C00004$$ VALID 30-9月 -19
LOB SYS_LOB0000092861C00004$$ VALID 30-9月 -19
INDEX SDE_MB_UK VALID 30-9月 -19
TABLE TABLES_LAST_EDIT_TIME VALID 30-9月 -19
SEQUENCE LAST_EDIT_ID_GENERATOR VALID 30-9月 -19
INDEX TBLS_LAST_EDIT_IX VALID 30-9月 -19
SEQUENCE LAYER_ID_GENERATOR VALID 30-9月 -19
SEQUENCE TABLE_ID_GENERATOR VALID 30-9月 -19
SEQUENCE RASTERCOLUMN_ID_GENERATOR VALID 30-9月 -19
SEQUENCE VERSION_ID_GENERATOR VALID 30-9月 -19
SEQUENCE METADATA_ID_GENERATOR VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
SEQUENCE LOCATOR_ID_GENERATOR VALID 30-9月 -19
SEQUENCE CONNECTION_ID_GENERATOR VALID 30-9月 -19
TABLE LAYER_LOCKS VALID 30-9月 -19
TABLE STATE_LOCKS VALID 30-9月 -19
TABLE TABLE_LOCKS VALID 30-9月 -19
INDEX TABLE_LOCKS_IDX1 VALID 30-9月 -19
TABLE OBJECT_LOCKS VALID 30-9月 -19
TABLE PROCESS_INFORMATION VALID 30-9月 -19
INDEX PROCESS_PK VALID 30-9月 -19
INDEX PROCESS_IDX1 VALID 30-9月 -19
INDEX PROCESS_IDX2 VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE SDE_TABLES_MODIFIED VALID 30-9月 -19
INDEX SDE_TABLES_MOD_IDX1 VALID 30-9月 -19
TABLE LINEAGES_MODIFIED VALID 30-9月 -19
INDEX LINEAGES_MOD_PK VALID 30-9月 -19
INDEX LINEAGES_MOD_IDX1 VALID 30-9月 -19
TABLE SDE_LOGFILE_POOL VALID 30-9月 -19
INDEX LOGFILE_POOL_PK VALID 30-9月 -19
TABLE SDE_LOGFILES VALID 30-9月 -19
INDEX SDE_LOGFILES_PK VALID 30-9月 -19
INDEX SDE_LOGFILES_UK VALID 30-9月 -19
TABLE SDE_LOGFILE_DATA VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX SDE_LOGFILE_DATA_IDX1 VALID 30-9月 -19
INDEX SDE_LOGFILE_DATA_IDX2 VALID 30-9月 -19
INDEX SDE_LOGFILE_DATA_IDX3 VALID 30-9月 -19
INDEX SDE_LOGFILE_DATA_IDX4 VALID 30-9月 -19
SEQUENCE SDE_LOGFILE_LID_GEN VALID 30-9月 -19
TABLE DBTUNE VALID 30-9月 -19
INDEX DBTUNE_UK VALID 30-9月 -19
INDEX SYS_IL0000092900C00003$$ VALID 30-9月 -19
LOB SYS_LOB0000092900C00003$$ VALID 30-9月 -19
TABLE SERVER_CONFIG VALID 30-9月 -19
INDEX SERVER_CONFIG_UK VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE SDENUMTAB VALID 30-9月 -19
PACKAGE SDE_UTIL VALID 30-9月 -19
PACKAGE BODY SDE_UTIL VALID 30-9月 -19
PACKAGE METADATA_UTIL VALID 30-9月 -19
PACKAGE BODY METADATA_UTIL VALID 30-9月 -19
PACKAGE REGISTRY_UTIL VALID 30-9月 -19
PACKAGE BODY REGISTRY_UTIL VALID 30-9月 -19
PACKAGE PINFO_UTIL VALID 30-9月 -19
PACKAGE BODY PINFO_UTIL VALID 30-9月 -19
PACKAGE LOCK_UTIL VALID 30-9月 -19
PACKAGE BODY LOCK_UTIL VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
PACKAGE VERSION_UTIL VALID 30-9月 -19
PACKAGE BODY VERSION_UTIL VALID 30-9月 -19
PACKAGE SREF_UTIL VALID 30-9月 -19
PACKAGE BODY SREF_UTIL VALID 30-9月 -19
PACKAGE LAYERS_UTIL VALID 30-9月 -19
PACKAGE BODY LAYERS_UTIL VALID 30-9月 -19
PACKAGE RASTERCOLUMNS_UTIL VALID 30-9月 -19
PACKAGE BODY RASTERCOLUMNS_UTIL VALID 30-9月 -19
PACKAGE LOCATOR_UTIL VALID 30-9月 -19
PACKAGE BODY LOCATOR_UTIL VALID 30-9月 -19
PACKAGE DBTUNE_UTIL VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
PACKAGE BODY DBTUNE_UTIL VALID 30-9月 -19
PACKAGE VERSION_USER_DDL VALID 30-9月 -19
PACKAGE BODY VERSION_USER_DDL VALID 30-9月 -19
PACKAGE SVR_CONFIG_UTIL VALID 30-9月 -19
PACKAGE BODY SVR_CONFIG_UTIL VALID 30-9月 -19
PACKAGE XML_UTIL VALID 30-9月 -19
PACKAGE BODY XML_UTIL VALID 30-9月 -19
PACKAGE LOGFILE_UTIL VALID 30-9月 -19
PACKAGE BODY LOGFILE_UTIL VALID 30-9月 -19
PACKAGE KEYSET_UTIL VALID 30-9月 -19
PACKAGE BODY KEYSET_UTIL VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
PACKAGE ARCHIVE_UTIL VALID 30-9月 -19
PACKAGE BODY ARCHIVE_UTIL VALID 30-9月 -19
PACKAGE LAYER_STATS_UTIL VALID 30-9月 -19
PACKAGE BODY LAYER_STATS_UTIL VALID 30-9月 -19
PACKAGE SDO_UTIL VALID 30-9月 -19
PACKAGE BODY SDO_UTIL VALID 30-9月 -19
PACKAGE BRANCH_UTIL VALID 30-9月 -19
PACKAGE BODY BRANCH_UTIL VALID 30-9月 -19
PACKAGE INSTANCES_UTIL VALID 30-9月 -19
PACKAGE BODY INSTANCES_UTIL VALID 30-9月 -19
TRIGGER LAST_EDIT_TIME_INSERT_TG VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
LIBRARY ST_SHAPELIB VALID 30-9月 -19
TABLE ST_COORDINATE_SYSTEMS VALID 30-9月 -19
INDEX ST_CRDSYS_PK VALID 30-9月 -19
TRIGGER TG_ST_CREF_SYS VALID 30-9月 -19
SEQUENCE ST_SPREF_SEQ VALID 30-9月 -19
TABLE ST_SPATIAL_REFERENCES VALID 30-9月 -19
INDEX ST_SPREFS_PK VALID 30-9月 -19
TRIGGER TG_ST_SPATIAL_REF_SRID VALID 30-9月 -19
SEQUENCE ST_GEOM_ID_SEQ VALID 30-9月 -19
TABLE ST_GEOMETRY_COLUMNS VALID 30-9月 -19
INDEX GEOM_COLS_PK VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX GEOM_ID_UK VALID 30-9月 -19
TRIGGER TG_GCOL_NAME VALID 30-9月 -19
VIEW USER_ST_GEOMETRY_COLUMNS_V VALID 30-9月 -19
VIEW ALL_ST_GEOMETRY_COLUMNS_V VALID 30-9月 -19
TYPE SP_GRID_INFO VALID 30-9月 -19
TYPE ST_FUNCS_ARRAY VALID 30-9月 -19
TABLE ST_GEOMETRY_INDEX VALID 30-9月 -19
INDEX ST_GEOM_IDX_UK VALID 30-9月 -19
INDEX SYS_IL0000092968C00025$$ VALID 30-9月 -19
LOB SYS_LOB0000092968C00025$$ VALID 30-9月 -19
INDEX ST_GEOM_IDX_UK2 VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TRIGGER TG_ST_GEOMINDEX_NAME VALID 30-9月 -19
VIEW USER_ST_GEOM_INDEX_V VALID 30-9月 -19
TABLE ST_UNITS_OF_MEASURE VALID 30-9月 -19
TABLE ST_PARTITION_INDEX VALID 30-9月 -19
INDEX ST_PI_UK2 VALID 30-9月 -19
TRIGGER DB_EV_DROP_ST_METADATA VALID 30-9月 -19
TRIGGER DB_EV_ALTER_ST_METADATA VALID 30-9月 -19
TRIGGER DB_EV_RENAME_ST_METADATA VALID 30-9月 -19
TYPE FLT_ARRAY_TAB VALID 30-9月 -19
TYPE INT_ARRAY_TAB VALID 30-9月 -19
TYPE BND_ROWID_TAB VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE BLOB_ARRAY_TAB VALID 30-9月 -19
PACKAGE ST_GEOMETRY_SHAPELIB_PKG VALID 30-9月 -19
PACKAGE BODY ST_GEOMETRY_SHAPELIB_PKG VALID 30-9月 -19
PACKAGE ST_TYPE_USER VALID 30-9月 -19
PACKAGE BODY ST_TYPE_USER VALID 30-9月 -19
PACKAGE ST_TYPE_UTIL VALID 30-9月 -19
PACKAGE BODY ST_TYPE_UTIL VALID 30-9月 -19
PACKAGE ST_GEOM_UTIL VALID 30-9月 -19
PACKAGE BODY ST_GEOM_UTIL VALID 30-9月 -19
PACKAGE ST_GEOM_COLS_UTIL VALID 30-9月 -19
PACKAGE BODY ST_GEOM_COLS_UTIL VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
PACKAGE ST_SPREF_UTIL VALID 30-9月 -19
PACKAGE BODY ST_SPREF_UTIL VALID 30-9月 -19
PACKAGE ST_CREF_UTIL VALID 30-9月 -19
PACKAGE BODY ST_CREF_UTIL VALID 30-9月 -19
TYPE ST_GEOMETRY VALID 30-9月 -19
TYPE BODY ST_GEOMETRY VALID 30-9月 -19
PACKAGE SPX_UTIL VALID 30-9月 -19
PACKAGE BODY SPX_UTIL VALID 30-9月 -19
PACKAGE ST_TYPE_EXPORT VALID 30-9月 -19
PACKAGE BODY ST_TYPE_EXPORT VALID 30-9月 -19
TYPE ST_POINT VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE BODY ST_POINT VALID 30-9月 -19
TYPE ST_CURVE VALID 30-9月 -19
TYPE BODY ST_CURVE VALID 30-9月 -19
TYPE ST_SURFACE VALID 30-9月 -19
TYPE BODY ST_SURFACE VALID 30-9月 -19
TYPE ST_GEOMCOLLECTION VALID 30-9月 -19
TYPE BODY ST_GEOMCOLLECTION VALID 30-9月 -19
TYPE ST_LINESTRING VALID 30-9月 -19
TYPE BODY ST_LINESTRING VALID 30-9月 -19
TYPE ST_POLYGON VALID 30-9月 -19
TYPE BODY ST_POLYGON VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE ST_MULTIPOINT VALID 30-9月 -19
TYPE BODY ST_MULTIPOINT VALID 30-9月 -19
TYPE ST_MULTICURVE VALID 30-9月 -19
TYPE BODY ST_MULTICURVE VALID 30-9月 -19
TYPE ST_MULTISURFACE VALID 30-9月 -19
TYPE BODY ST_MULTISURFACE VALID 30-9月 -19
TYPE ST_MULTILINESTRING VALID 30-9月 -19
TYPE BODY ST_MULTILINESTRING VALID 30-9月 -19
TYPE ST_MULTIPOLYGON VALID 30-9月 -19
TYPE BODY ST_MULTIPOLYGON VALID 30-9月 -19
TYPE ST_POINTFROMTEXT VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE BODY ST_POINTFROMTEXT VALID 30-9月 -19
TYPE ST_MPOINTFROMTEXT VALID 30-9月 -19
TYPE BODY ST_MPOINTFROMTEXT VALID 30-9月 -19
TYPE ST_LINEFROMTEXT VALID 30-9月 -19
TYPE BODY ST_LINEFROMTEXT VALID 30-9月 -19
TYPE ST_MLINEFROMTEXT VALID 30-9月 -19
TYPE BODY ST_MLINEFROMTEXT VALID 30-9月 -19
TYPE ST_POLYFROMTEXT VALID 30-9月 -19
TYPE BODY ST_POLYFROMTEXT VALID 30-9月 -19
TYPE ST_MPOLYFROMTEXT VALID 30-9月 -19
TYPE BODY ST_MPOLYFROMTEXT VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE ST_GEOMFROMTEXT VALID 30-9月 -19
TYPE BODY ST_GEOMFROMTEXT VALID 30-9月 -19
PACKAGE ST_DOMAIN_OPERATORS VALID 30-9月 -19
PACKAGE BODY ST_DOMAIN_OPERATORS VALID 30-9月 -19
PACKAGE ST_GEOMETRY_OPERATORS VALID 30-9月 -19
PACKAGE BODY ST_GEOMETRY_OPERATORS VALID 30-9月 -19
PACKAGE ST_RELATION_OPERATORS VALID 30-9月 -19
PACKAGE BODY ST_RELATION_OPERATORS VALID 30-9月 -19
TYPE ST_DOMAIN_METHODS VALID 30-9月 -19
TYPE BODY ST_DOMAIN_METHODS VALID 30-9月 -19
TYPE ST_DOMAIN_STATS VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE BODY ST_DOMAIN_STATS VALID 30-9月 -19
OPERATOR ST_CONTAINS VALID 30-9月 -19
OPERATOR ST_WITHIN VALID 30-9月 -19
OPERATOR ST_INTERSECTS VALID 30-9月 -19
OPERATOR ST_OVERLAPS VALID 30-9月 -19
OPERATOR ST_TOUCHES VALID 30-9月 -19
OPERATOR ST_CROSSES VALID 30-9月 -19
OPERATOR ST_ORDERINGEQUALS VALID 30-9月 -19
OPERATOR ST_EQUALS VALID 30-9月 -19
OPERATOR ST_BUFFER_INTERSECTS VALID 30-9月 -19
OPERATOR ST_ASTEXT VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
OPERATOR ST_ASBINARY VALID 30-9月 -19
OPERATOR ST_GEOMFROMWKB VALID 30-9月 -19
OPERATOR ST_POINTFROMWKB VALID 30-9月 -19
OPERATOR ST_LINEFROMWKB VALID 30-9月 -19
OPERATOR ST_POLYFROMWKB VALID 30-9月 -19
OPERATOR ST_MPOINTFROMWKB VALID 30-9月 -19
OPERATOR ST_MLINEFROMWKB VALID 30-9月 -19
OPERATOR ST_MPOLYFROMWKB VALID 30-9月 -19
OPERATOR ST_BOUNDARY VALID 30-9月 -19
OPERATOR ST_COORDDIM VALID 30-9月 -19
OPERATOR ST_DIMENSION VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
OPERATOR ST_ENVELOPE VALID 30-9月 -19
OPERATOR ST_GEOMETRYTYPE VALID 30-9月 -19
OPERATOR ST_IS3D VALID 30-9月 -19
OPERATOR ST_ISMEASURED VALID 30-9月 -19
OPERATOR ST_ISCLOSED VALID 30-9月 -19
OPERATOR ST_ISEMPTY VALID 30-9月 -19
OPERATOR ST_ISRING VALID 30-9月 -19
OPERATOR ST_ISSIMPLE VALID 30-9月 -19
OPERATOR ST_AREA VALID 30-9月 -19
OPERATOR ST_BUFFER VALID 30-9月 -19
OPERATOR ST_RELATE VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
OPERATOR ST_CENTROID VALID 30-9月 -19
OPERATOR ST_CONVEXHULL VALID 30-9月 -19
OPERATOR ST_STARTPOINT VALID 30-9月 -19
OPERATOR ST_ENDPOINT VALID 30-9月 -19
OPERATOR ST_POINTONSURFACE VALID 30-9月 -19
OPERATOR ST_EXTERIORRING VALID 30-9月 -19
OPERATOR ST_INTERIORRINGN VALID 30-9月 -19
OPERATOR ST_NUMINTERIORRING VALID 30-9月 -19
OPERATOR ST_NUMGEOMETRIES VALID 30-9月 -19
OPERATOR ST_GEOMETRYN VALID 30-9月 -19
OPERATOR ST_DIFFERENCE VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
OPERATOR ST_UNION VALID 30-9月 -19
OPERATOR ST_SYMMETRICDIFF VALID 30-9月 -19
OPERATOR ST_POINTN VALID 30-9月 -19
OPERATOR ST_INTERSECTION VALID 30-9月 -19
OPERATOR ST_TRANSFORM VALID 30-9月 -19
OPERATOR ST_ENTITY VALID 30-9月 -19
OPERATOR ST_NUMPOINTS VALID 30-9月 -19
OPERATOR ST_MINX VALID 30-9月 -19
OPERATOR ST_MAXX VALID 30-9月 -19
OPERATOR ST_MINY VALID 30-9月 -19
OPERATOR ST_MAXY VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
OPERATOR ST_MINZ VALID 30-9月 -19
OPERATOR ST_MAXZ VALID 30-9月 -19
OPERATOR ST_MINM VALID 30-9月 -19
OPERATOR ST_MAXM VALID 30-9月 -19
OPERATOR ST_LENGTH VALID 30-9月 -19
OPERATOR ST_SRID VALID 30-9月 -19
OPERATOR ST_X VALID 30-9月 -19
OPERATOR ST_Y VALID 30-9月 -19
OPERATOR ST_Z VALID 30-9月 -19
OPERATOR ST_M VALID 30-9月 -19
OPERATOR ST_DISTANCE VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
OPERATOR ST_DWITHIN VALID 30-9月 -19
OPERATOR ST_DISJOINT VALID 30-9月 -19
OPERATOR ST_VERIFY VALID 30-9月 -19
OPERATOR SDEXMLTOTEXT VALID 30-9月 -19
OPERATOR ST_GEOHASH VALID 30-9月 -19
OPERATOR ST_POINTFROMGEOHASH VALID 30-9月 -19
OPERATOR ST_GEOMFROMGEOHASH VALID 30-9月 -19
OPERATOR ST_GEOSQUARE VALID 30-9月 -19
OPERATOR ST_POINTFROMGEOSQUARE VALID 30-9月 -19
OPERATOR ST_GEOMFROMGEOSQUARE VALID 30-9月 -19
OPERATOR ST_GEOHEXCODE VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
OPERATOR ST_GEOHEXTRIANGLE VALID 30-9月 -19
OPERATOR ST_GEOMETRYFROMGEOHEXTRI VALID 30-9月 -19
OPERATOR ST_GEOHEXCODEFROMTRIANGLECODE VALID 30-9月 -19
OPERATOR ST_POINTFROMGEOHEXTRI VALID 30-9月 -19
OPERATOR ST_POINTFROMGEOHEXTRIANGLE VALID 30-9月 -19
OPERATOR ST_GEOMETRYFROMGEOHEXTRIANGLE VALID 30-9月 -19
OPERATOR ST_GEOMETRYFROMTRIANGLECODE VALID 30-9月 -19
OPERATOR ST_ENVINTERSECTS VALID 30-9月 -19
INDEXTYPE ST_SPATIAL_INDEX VALID 30-9月 -19
TYPE STGEOM_AGGR_UNION VALID 30-9月 -19
TYPE BODY STGEOM_AGGR_UNION VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TYPE STGEOM_AGGR_INTERSECTION VALID 30-9月 -19
TYPE BODY STGEOM_AGGR_INTERSECTION VALID 30-9月 -19
TYPE STGEOM_AGGR_CONVEXHULL VALID 30-9月 -19
TYPE BODY STGEOM_AGGR_CONVEXHULL VALID 30-9月 -19
FUNCTION ST_AGGR_UNION VALID 30-9月 -19
FUNCTION ST_AGGR_INTERSECTION VALID 30-9月 -19
FUNCTION ST_AGGR_CONVEXHULL VALID 30-9月 -19
TRIGGER TG_LAYERS_SRID VALID 30-9月 -19
TRIGGER TG_SPATIAL_REF_AUTH_SRID VALID 30-9月 -19
TABLE GDB_TABLES_LAST_MODIFIED VALID 30-9月 -19
INDEX GDB_LMODIFIED_IX1 VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE GDB_ITEMS VALID 30-9月 -19
INDEX SYS_IL0000093152C00014$$ VALID 30-9月 -19
LOB SYS_LOB0000093152C00014$$ VALID 30-9月 -19
INDEX SYS_IL0000093152C00009$$ VALID 30-9月 -19
LOB SYS_LOB0000093152C00009$$ VALID 30-9月 -19
INDEX R6_SDE_ROWID_UK VALID 30-9月 -19
SEQUENCE R6 VALID 30-9月 -19
INDEX GDB_ITEMS_UUID_IDX VALID 30-9月 -19
TABLE SDE_XML_DOC1 VALID 30-9月 -19
INDEX XML_DOC1_PK VALID 30-9月 -19
INDEX SYS_IL0000093160C00004$$ VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
LOB SYS_LOB0000093160C00004$$ VALID 30-9月 -19
INDEX SYS_IL0000093160C00003$$ VALID 30-9月 -19
LOB SYS_LOB0000093160C00003$$ VALID 30-9月 -19
INDEX XML_DOC1_IX VALID 30-9月 -19
INDEX XMLDOCIX1_TX VALID 30-9月 -19
TABLE DR$XMLDOCIX1_TX$I VALID 30-9月 -19
INDEX SYS_IL0000093168C00006$$ VALID 30-9月 -19
LOB SYS_LOB0000093168C00006$$ VALID 30-9月 -19
TABLE DR$XMLDOCIX1_TX$K VALID 30-9月 -19
INDEX SYS_IOT_TOP_93171 VALID 30-9月 -19
TABLE DR$XMLDOCIX1_TX$R VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX DRC$XMLDOCIX1_TX$R VALID 30-9月 -19
INDEX SYS_IL0000093173C00002$$ VALID 30-9月 -19
LOB SYS_LOB0000093173C00002$$ VALID 30-9月 -19
TABLE DR$XMLDOCIX1_TX$N VALID 30-9月 -19
INDEX SYS_IOT_TOP_93177 VALID 30-9月 -19
INDEX DR$XMLDOCIX1_TX$X VALID 30-9月 -19
SEQUENCE XML_DOC1_ID_GENERATOR VALID 30-9月 -19
INDEX SDE_XMLID_IX1 VALID 30-9月 -19
TABLE SDE_XML_DOC2 VALID 30-9月 -19
INDEX XML_DOC2_PK VALID 30-9月 -19
INDEX SYS_IL0000093182C00004$$ VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
LOB SYS_LOB0000093182C00004$$ VALID 30-9月 -19
INDEX SYS_IL0000093182C00003$$ VALID 30-9月 -19
LOB SYS_LOB0000093182C00003$$ VALID 30-9月 -19
INDEX XML_DOC2_IX VALID 30-9月 -19
INDEX XMLDOCIX2_TX VALID 30-9月 -19
TABLE DR$XMLDOCIX2_TX$I VALID 30-9月 -19
INDEX SYS_IL0000093190C00006$$ VALID 30-9月 -19
LOB SYS_LOB0000093190C00006$$ VALID 30-9月 -19
TABLE DR$XMLDOCIX2_TX$K VALID 30-9月 -19
INDEX SYS_IOT_TOP_93193 VALID 30-9月 -19
TABLE DR$XMLDOCIX2_TX$R VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX DRC$XMLDOCIX2_TX$R VALID 30-9月 -19
INDEX SYS_IL0000093195C00002$$ VALID 30-9月 -19
LOB SYS_LOB0000093195C00002$$ VALID 30-9月 -19
TABLE DR$XMLDOCIX2_TX$N VALID 30-9月 -19
INDEX SYS_IOT_TOP_93199 VALID 30-9月 -19
INDEX DR$XMLDOCIX2_TX$X VALID 30-9月 -19
SEQUENCE XML_DOC2_ID_GENERATOR VALID 30-9月 -19
INDEX SDE_XMLID_IX2 VALID 30-9月 -19
TABLE SDE_XML_DOC3 VALID 30-9月 -19
INDEX XML_DOC3_PK VALID 30-9月 -19
INDEX SYS_IL0000093204C00004$$ VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
LOB SYS_LOB0000093204C00004$$ VALID 30-9月 -19
INDEX SYS_IL0000093204C00003$$ VALID 30-9月 -19
LOB SYS_LOB0000093204C00003$$ VALID 30-9月 -19
INDEX XML_DOC3_IX VALID 30-9月 -19
INDEX XMLDOCIX3_TX VALID 30-9月 -19
TABLE DR$XMLDOCIX3_TX$I VALID 30-9月 -19
INDEX SYS_IL0000093212C00006$$ VALID 30-9月 -19
LOB SYS_LOB0000093212C00006$$ VALID 30-9月 -19
TABLE DR$XMLDOCIX3_TX$K VALID 30-9月 -19
INDEX SYS_IOT_TOP_93215 VALID 30-9月 -19
TABLE DR$XMLDOCIX3_TX$R VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX DRC$XMLDOCIX3_TX$R VALID 30-9月 -19
INDEX SYS_IL0000093217C00002$$ VALID 30-9月 -19
LOB SYS_LOB0000093217C00002$$ VALID 30-9月 -19
TABLE DR$XMLDOCIX3_TX$N VALID 30-9月 -19
INDEX SYS_IOT_TOP_93221 VALID 30-9月 -19
INDEX DR$XMLDOCIX3_TX$X VALID 30-9月 -19
SEQUENCE XML_DOC3_ID_GENERATOR VALID 30-9月 -19
INDEX SDE_XMLID_IX3 VALID 30-9月 -19
INDEX SYS_IL0000093152C00033$$ VALID 30-9月 -19
LOB SYS_LOB0000093152C00033$$ VALID 30-9月 -19
INDEX A1_IX1 VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE S1_IDX$ VALID 30-9月 -19
INDEX S1$_IX1 VALID 30-9月 -19
INDEX S1$_IX2 VALID 30-9月 -19
INDEX ITEMS_TYPE_IDX VALID 30-9月 -19
INDEX ITEMS_NAME_IDX VALID 30-9月 -19
INDEX ITEMS_PHYSICALNAME_IDX VALID 30-9月 -19
TRIGGER GDB_ITEMS_TAB_TR VALID 30-9月 -19
TABLE GDB_ITEMRELATIONSHIPS VALID 30-9月 -19
INDEX R7_SDE_ROWID_UK VALID 30-9月 -19
SEQUENCE R7 VALID 30-9月 -19
INDEX GDB_ITEMRELATIONSHIPS_UUID_IDX VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE SDE_XML_DOC4 VALID 30-9月 -19
INDEX XML_DOC4_PK VALID 30-9月 -19
INDEX SYS_IL0000093240C00004$$ VALID 30-9月 -19
LOB SYS_LOB0000093240C00004$$ VALID 30-9月 -19
INDEX SYS_IL0000093240C00003$$ VALID 30-9月 -19
LOB SYS_LOB0000093240C00003$$ VALID 30-9月 -19
INDEX XML_DOC4_IX VALID 30-9月 -19
INDEX XMLDOCIX4_TX VALID 30-9月 -19
TABLE DR$XMLDOCIX4_TX$I VALID 30-9月 -19
INDEX SYS_IL0000093248C00006$$ VALID 30-9月 -19
LOB SYS_LOB0000093248C00006$$ VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE DR$XMLDOCIX4_TX$K VALID 30-9月 -19
INDEX SYS_IOT_TOP_93251 VALID 30-9月 -19
TABLE DR$XMLDOCIX4_TX$R VALID 30-9月 -19
INDEX DRC$XMLDOCIX4_TX$R VALID 30-9月 -19
INDEX SYS_IL0000093253C00002$$ VALID 30-9月 -19
LOB SYS_LOB0000093253C00002$$ VALID 30-9月 -19
TABLE DR$XMLDOCIX4_TX$N VALID 30-9月 -19
INDEX SYS_IOT_TOP_93257 VALID 30-9月 -19
INDEX DR$XMLDOCIX4_TX$X VALID 30-9月 -19
SEQUENCE XML_DOC4_ID_GENERATOR VALID 30-9月 -19
INDEX SDE_XMLID_IX4 VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX GDB_ITEMREL_TYPE_IDX VALID 30-9月 -19
INDEX GDB_ITEMREL_ORIGINID_IDX VALID 30-9月 -19
INDEX GDB_ITEMREL_DESTID_IDX VALID 30-9月 -19
TRIGGER GDB_ITEMS_REL_TR VALID 30-9月 -19
TABLE GDB_ITEMTYPES VALID 30-9月 -19
INDEX R8_SDE_ROWID_UK VALID 30-9月 -19
SEQUENCE R8 VALID 30-9月 -19
INDEX ITEMTYPES_UUID_IDX VALID 30-9月 -19
INDEX ITEMTYPES_NAME_IDX VALID 30-9月 -19
INDEX ITEMTYPES_PARENTTYPEID_IDX VALID 30-9月 -19
TRIGGER GDB_ITEM_TYP_TR VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
TABLE GDB_ITEMRELATIONSHIPTYPES VALID 30-9月 -19
INDEX R9_SDE_ROWID_UK VALID 30-9月 -19
SEQUENCE R9 VALID 30-9月 -19
INDEX ITMRTYPES_UUID_IDX VALID 30-9月 -19
INDEX ITMRTYPES_NAME_IDX VALID 30-9月 -19
INDEX ITMRTYPES_FORWARDLABEL_IDX VALID 30-9月 -19
INDEX ITMRTYPES_BACKWARDLABEL_IDX VALID 30-9月 -19
INDEX ITMRTYPES_ORIGITEMTYPEID_IDX VALID 30-9月 -19
INDEX ITMRTYPES_DESTITEMTYPEID_IDX VALID 30-9月 -19
TRIGGER GDB_ITEM_REL_TYP_TR VALID 30-9月 -19
TABLE GDB_REPLICALOG VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
INDEX R10_SDE_ROWID_UK VALID 30-9月 -19
SEQUENCE R10 VALID 30-9月 -19
TRIGGER GDB_REP_LOG_TR VALID 30-9月 -19
TABLE GDB_LOCKS VALID 30-9月 -19
INDEX R11_SDE_ROWID_UK VALID 30-9月 -19
SEQUENCE R11 VALID 30-9月 -19
INDEX GDB_LOCKS_IX1 VALID 30-9月 -19
INDEX GDB_LOCKS_COND_IDX VALID 30-9月 -19
TABLE GDB_CONFLICTS VALID 30-9月 -19
INDEX GDB_CONFLICTS_IDX VALID 30-9月 -19
VIEW GDB_ITEMS_VW VALID 30-9月 -19

OBJECT_TYPE OBJECT_NAME STATUS CREATED
-------------------- ------------------------------ ------- --------------
VIEW GDB_ITEMRELATIONSHIPS_VW VALID 30-9月 -19
PACKAGE GDB_UTIL VALID 30-9月 -19
PACKAGE BODY GDB_UTIL VALID 30-9月 -19

已选择 498 行。

6查看索引信息

SQL> set pagesize 100 linesize 1000
SQL> select index_name,table_name from user_indexes order by table_name;

INDEX_NAME TABLE_NAME
-------------------- --------------------
BRANCH_PK BRANCHES
BRANCH_UK BRANCHES
BRANCH_SN_IDX BRANCHES
BRANCH_BG_UK BRANCHES
BTM_UK BRANCH_TABLES_MODIFI
ED

COLREGISTRY_PK COLUMN_REGISTRY
SYS_IL0000092900C000 DBTUNE
03$$

DBTUNE_UK DBTUNE
SYS_IL0000093168C000 DR$XMLDOCIX1_TX$I
06$$

DR$XMLDOCIX1_TX$X DR$XMLDOCIX1_TX$I
SYS_IOT_TOP_93171 DR$XMLDOCIX1_TX$K
SYS_IOT_TOP_93177 DR$XMLDOCIX1_TX$N
SYS_IL0000093173C000 DR$XMLDOCIX1_TX$R
02$$

DRC$XMLDOCIX1_TX$R DR$XMLDOCIX1_TX$R
SYS_IL0000093190C000 DR$XMLDOCIX2_TX$I
06$$

DR$XMLDOCIX2_TX$X DR$XMLDOCIX2_TX$I
SYS_IOT_TOP_93193 DR$XMLDOCIX2_TX$K
SYS_IOT_TOP_93199 DR$XMLDOCIX2_TX$N
SYS_IL0000093195C000 DR$XMLDOCIX2_TX$R
02$$

DRC$XMLDOCIX2_TX$R DR$XMLDOCIX2_TX$R
DR$XMLDOCIX3_TX$X DR$XMLDOCIX3_TX$I
SYS_IL0000093212C000 DR$XMLDOCIX3_TX$I
06$$

SYS_IOT_TOP_93215 DR$XMLDOCIX3_TX$K
SYS_IOT_TOP_93221 DR$XMLDOCIX3_TX$N
SYS_IL0000093217C000 DR$XMLDOCIX3_TX$R
02$$

DRC$XMLDOCIX3_TX$R DR$XMLDOCIX3_TX$R
DR$XMLDOCIX4_TX$X DR$XMLDOCIX4_TX$I
SYS_IL0000093248C000 DR$XMLDOCIX4_TX$I
06$$

SYS_IOT_TOP_93251 DR$XMLDOCIX4_TX$K
SYS_IOT_TOP_93257 DR$XMLDOCIX4_TX$N
SYS_IL0000093253C000 DR$XMLDOCIX4_TX$R
02$$

DRC$XMLDOCIX4_TX$R DR$XMLDOCIX4_TX$R
GDB_CONFLICTS_IDX GDB_CONFLICTS
GDB_ITEMREL_DESTID_I GDB_ITEMRELATIONSHIP
DX S

GDB_ITEMREL_ORIGINID GDB_ITEMRELATIONSHIP
_IDX S

GDB_ITEMREL_TYPE_IDX GDB_ITEMRELATIONSHIP
S

R7_SDE_ROWID_UK GDB_ITEMRELATIONSHIP
S

SDE_XMLID_IX4 GDB_ITEMRELATIONSHIP
S

GDB_ITEMRELATIONSHIP GDB_ITEMRELATIONSHIP
S_UUID_IDX S

ITMRTYPES_DESTITEMTY GDB_ITEMRELATIONSHIP
PEID_IDX TYPES

ITMRTYPES_ORIGITEMTY GDB_ITEMRELATIONSHIP
PEID_IDX TYPES

ITMRTYPES_BACKWARDLA GDB_ITEMRELATIONSHIP
BEL_IDX TYPES

ITMRTYPES_FORWARDLAB GDB_ITEMRELATIONSHIP
EL_IDX TYPES

ITMRTYPES_NAME_IDX GDB_ITEMRELATIONSHIP
TYPES

ITMRTYPES_UUID_IDX GDB_ITEMRELATIONSHIP
TYPES

R9_SDE_ROWID_UK GDB_ITEMRELATIONSHIP
TYPES

A1_IX1 GDB_ITEMS
SDE_XMLID_IX2 GDB_ITEMS
SDE_XMLID_IX1 GDB_ITEMS
GDB_ITEMS_UUID_IDX GDB_ITEMS
R6_SDE_ROWID_UK GDB_ITEMS

INDEX_NAME TABLE_NAME
-------------------- --------------------
SDE_XMLID_IX3 GDB_ITEMS
ITEMS_NAME_IDX GDB_ITEMS
ITEMS_TYPE_IDX GDB_ITEMS
SYS_IL0000093152C000 GDB_ITEMS
33$$

SYS_IL0000093152C000 GDB_ITEMS
14$$

SYS_IL0000093152C000 GDB_ITEMS
09$$

ITEMS_PHYSICALNAME_I GDB_ITEMS
DX

ITEMTYPES_NAME_IDX GDB_ITEMTYPES
ITEMTYPES_UUID_IDX GDB_ITEMTYPES
R8_SDE_ROWID_UK GDB_ITEMTYPES
ITEMTYPES_PARENTTYPE GDB_ITEMTYPES
ID_IDX

R11_SDE_ROWID_UK GDB_LOCKS
GDB_LOCKS_IX1 GDB_LOCKS
GDB_LOCKS_COND_IDX GDB_LOCKS
R10_SDE_ROWID_UK GDB_REPLICALOG
GDB_LMODIFIED_IX1 GDB_TABLES_LAST_MODI
FIED

GEOCOL_PK GEOMETRY_COLUMNS
SYS_C0010392 INSTANCES
INSTANCES_PK INSTANCES
LAYERS_PK LAYERS
LAYERS_UK LAYERS
LINEAGES_MOD_IDX1 LINEAGES_MODIFIED
LINEAGES_MOD_PK LINEAGES_MODIFIED
LOCATORS_UK LOCATORS
LOCATORS_PK LOCATORS
METADATA_PK METADATA
SDE_MB_UK MULTIBRANCH_TABLES
SYS_IL0000092861C000 MULTIBRANCH_TABLES
04$$

MVTABLES_MODIFIED_IX MVTABLES_MODIFIED
PROCESS_PK PROCESS_INFORMATION
PROCESS_IDX2 PROCESS_INFORMATION
PROCESS_IDX1 PROCESS_INFORMATION
RASCOL_PK RASTER_COLUMNS
RASCOL_UK RASTER_COLUMNS
S1$_IX1 S1_IDX$
S1$_IX2 S1_IDX$
ARCHIVES_UK SDE_ARCHIVES
ARCHIVES_PK SDE_ARCHIVES
LAYER_STATS_UK SDE_LAYER_STATS
SDE_LOGFILES_UK SDE_LOGFILES
SDE_LOGFILES_PK SDE_LOGFILES
SDE_LOGFILE_DATA_IDX SDE_LOGFILE_DATA
4

SDE_LOGFILE_DATA_IDX SDE_LOGFILE_DATA
3

SDE_LOGFILE_DATA_IDX SDE_LOGFILE_DATA
1

SDE_LOGFILE_DATA_IDX SDE_LOGFILE_DATA
2

LOGFILE_POOL_PK SDE_LOGFILE_POOL
SDE_TABLES_MOD_IDX1 SDE_TABLES_MODIFIED
XML_COLUMNS_PK SDE_XML_COLUMNS
XML_COLUMNS_UK SDE_XML_COLUMNS
XMLDOCIX1_TX SDE_XML_DOC1
SYS_IL0000093160C000 SDE_XML_DOC1
04$$

SYS_IL0000093160C000 SDE_XML_DOC1
03$$

XML_DOC1_PK SDE_XML_DOC1
XML_DOC1_IX SDE_XML_DOC1
SYS_IL0000093182C000 SDE_XML_DOC2
03$$

SYS_IL0000093182C000 SDE_XML_DOC2
04$$

XML_DOC2_PK SDE_XML_DOC2
XML_DOC2_IX SDE_XML_DOC2
XMLDOCIX2_TX SDE_XML_DOC2
SYS_IL0000093204C000 SDE_XML_DOC3
04$$

XML_DOC3_PK SDE_XML_DOC3
XML_DOC3_IX SDE_XML_DOC3
XMLDOCIX3_TX SDE_XML_DOC3
SYS_IL0000093204C000 SDE_XML_DOC3
03$$

INDEX_NAME TABLE_NAME
-------------------- --------------------

XMLDOCIX4_TX SDE_XML_DOC4
XML_DOC4_IX SDE_XML_DOC4
XML_DOC4_PK SDE_XML_DOC4
SYS_IL0000093240C000 SDE_XML_DOC4
04$$

SYS_IL0000093240C000 SDE_XML_DOC4
03$$

XML_INDEXES_PK SDE_XML_INDEXES
XML_INDEXES_UK SDE_XML_INDEXES
XML_INDEXTAGS_PK SDE_XML_INDEX_TAGS
XML_INDEXTAGS_IX1 SDE_XML_INDEX_TAGS
XML_INDEXTAGS_IX2 SDE_XML_INDEX_TAGS
SERVER_CONFIG_UK SERVER_CONFIG
SPATIAL_REF_PK SPATIAL_REFERENCES
STATES_PK STATES
STATES_CUK STATES
LINEAGES_PK STATE_LINEAGES
LINEAGE_ID_IDX2 STATE_LINEAGES
ST_CRDSYS_PK ST_COORDINATE_SYSTEM
S

GEOM_COLS_PK ST_GEOMETRY_COLUMNS
GEOM_ID_UK ST_GEOMETRY_COLUMNS
SYS_IL0000092968C000 ST_GEOMETRY_INDEX
25$$

ST_GEOM_IDX_UK ST_GEOMETRY_INDEX
ST_GEOM_IDX_UK2 ST_GEOMETRY_INDEX
ST_PI_UK2 ST_PARTITION_INDEX
ST_SPREFS_PK ST_SPATIAL_REFERENCE
S

TBLS_LAST_EDIT_IX TABLES_LAST_EDIT_TIM
E

TABLE_LOCKS_IDX1 TABLE_LOCKS
REGISTRY_PK TABLE_REGISTRY
REGISTRY_UK2 TABLE_REGISTRY
OWNER_MVV_IX TABLE_REGISTRY
VERSIONS_UK2 VERSIONS
VERSIONS_UK VERSIONS
VER_STATE_IX VERSIONS

已选择 147 行。