无特殊说明,下述内容中 ArcSDE版本为9.2,Oracle数据库版本为9.2.0.8.0。
通过设置或调整ArcSDE配置参数优化ArcSDE性能提升不是太大(ArcSDE参数信息http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=ArcSDE_initialization_parameters),建议主要优化Oracle,数据库优化分为以下三步:
1、内存优化
ArcSDE安装完成后,不要立即运行Post Installation,应先对数据库内存进行优化。数据库内存优化请参看http://blog.csdn.net/chenanlin1981/archive/2007/04/05/1553160.aspx。
2、创建存储表空间和SDE用户
2.1 创建表空间
可根据磁盘情况创建表空间,普通硬盘尽量把表空间分散在不两只的硬盘上,SCSI无所谓。以下为创建表空间脚本
---- 创建F表空间SPATIAL_MAP_SPACE_F
Create Tablespace SPATIAL_MAP_SPACE_F
Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F01.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F02.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F03.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F04.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F05.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F06.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F07.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F08.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F09.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F/SPATIAL_MAP_SPACE_F10.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建F表索引表空间SPATIAL_MAP_SPACE_F_I
Create Tablespace SPATIAL_MAP_SPACE_F_I
Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I01.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_MAP_SPACE_F_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I02.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I03.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I04.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I05.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_F_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_F_I/SPATIAL_MAP_SPACE_F_I06.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建RAS表空间SPATIAL_RASTER_SPACE
Create Tablespace SPATIAL_RASTER_SPACE
Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE01.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE02.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE03.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE04.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE05.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE06.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE07.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE08.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE09.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE10.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE11.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE12.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE13.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE14.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE15.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE16.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE17.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE18.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE19.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE/SPATIAL_RASTER_SPACE20.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建RAS表索引表空间SPATIAL_RASTER_SPACE_I
Create Tablespace SPATIAL_RASTER_SPACE_I
Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I01.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_RASTER_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I02.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I03.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I04.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I05.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_RASTER_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_RASTER_SPACE_I/SPATIAL_RASTER_SPACE_I06.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建S表空间SPATIAL_MAP_SPACE_S
Create Tablespace SPATIAL_MAP_SPACE_S
Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S01.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_MAP_SPACE_S
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S02.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S03.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S04.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S05.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S06.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S07.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S/SPATIAL_MAP_SPACE_S08.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建S表索引表空间SPATIAL_MAP_SPACE_S_I
Create Tablespace SPATIAL_MAP_SPACE_S_I
Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I01.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_MAP_SPACE_S_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I02.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I03.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I04.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I05.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_S_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_S_I/SPATIAL_MAP_SPACE_S_I06.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建SDE表空间SPATIAL_MAP_SPACE
Create Tablespace SPATIAL_MAP_SPACE
Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE01.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE02.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE03.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE04.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE05.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE06.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE07.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE08.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE09.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE/SPATIAL_MAP_SPACE10.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建SDE索引表空间SPATIAL_MAP_SPACE_I
Create Tablespace SPATIAL_MAP_SPACE_I
Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I01.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_MAP_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I02.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I03.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I04.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I05.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_MAP_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_MAP_SPACE_I/SPATIAL_MAP_SPACE_I06.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建SDE,XML表空间SPATIAL_XML_SPACE
Create Tablespace SPATIAL_XML_SPACE
Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE01.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE02.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE03.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE04.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE05.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE06.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE07.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE08.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE09.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE/SPATIAL_XML_SPACE10.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建SDE,XML索引表空间SPATIAL_XML_SPACE_I
Create Tablespace SPATIAL_XML_SPACE_I
Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I01.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited Online;
Alter Tablespace SPATIAL_XML_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I02.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I03.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I04.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I05.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_XML_SPACE_I
Add Datafile 'C:/ORACLETABLESPACE/SPATIAL_XML_SPACE_I/SPATIAL_XML_SPACE_I06.dbf' size 1024M reuse
Autoextend on next 10M Maxsize unlimited;
---- 创建临时表空间SPATIAL_TEMP_SPACE
Create temporary Tablespace SPATIAL_TEMP_SPACE
TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE01.dbf' size 1024M reuse
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE02.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE03.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE04.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE05.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE06.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE07.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE08.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE09.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
Alter Tablespace SPATIAL_TEMP_SPACE
Add TEMPFILE 'C:/ORACLETABLESPACE/SPATIAL_TEMP_SPACE/SPATIAL_TEMP_SPACE10.dbf' size 1024M Reuse
Autoextend on next 10M Maxsize unlimited;
2.2 创建SDE用户
建议SDE只存储ArcSDE系统表和系统信息,然后根据用途和数据情况创建其它用户,使用时不要直接使用sde用户。例如有矢量和影像数据,可创建MAP和RASTER用户。根据创建表空间脚本,指定MAP和RASTER用户的默认表空间和临时表空间,创建脚本如下:
--修改SYS和SYSTEM默认表空间和临时表空,请根据情况决定是否修改。
Alter USER SYS DEFAULT TABLESPACE SPATIAL_MAP_SPACE;
Alter USER SYS TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
Alter USER SYSTEM DEFAULT TABLESPACE SPATIAL_MAP_SPACE;
Alter USER SYSTEM TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
--创建空间数据管理角色,这是SDE用户要求的最低权限
DROP ROLE SDE_UPGRADE;
CREATE ROLE SDE_UPGRADE;
GRANT CREATE SESSION TO SDE_UPGRADE;
GRANT CREATE TABLE TO SDE_UPGRADE;
GRANT CREATE PROCEDURE TO SDE_UPGRADE;
GRANT CREATE SEQUENCE TO SDE_UPGRADE;
GRANT CREATE TRIGGER TO SDE_UPGRADE;
GRANT CREATE TYPE TO SDE_UPGRADE;
GRANT CREATE LIBRARY TO SDE_UPGRADE;
GRANT CREATE PUBLIC SYNONYM TO SDE_UPGRADE;
GRANT DROP PUBLIC SYNONYM TO SDE_UPGRADE;
GRANT ALTER ANY INDEX TO SDE_UPGRADE;
GRANT ALTER ANY TABLE TO SDE_UPGRADE;
GRANT ANALYZE ANY TO SDE_UPGRADE;
GRANT CREATE ANY INDEX TO SDE_UPGRADE;
GRANT DROP ANY INDEX TO SDE_UPGRADE;
GRANT CREATE ANY PROCEDURE TO SDE_UPGRADE;
GRANT DROP ANY PROCEDURE TO SDE_UPGRADE;
GRANT CREATE ANY SEQUENCE TO SDE_UPGRADE;
GRANT DROP ANY SEQUENCE TO SDE_UPGRADE;
GRANT CREATE ANY TRIGGER TO SDE_UPGRADE;
GRANT CREATE ANY VIEW TO SDE_UPGRADE;
GRANT DROP ANY TABLE TO SDE_UPGRADE;
GRANT DROP ANY VIEW TO SDE_UPGRADE;
GRANT EXECUTE ANY PROCEDURE TO SDE_UPGRADE;
GRANT SELECT ANY SEQUENCE TO SDE_UPGRADE;
GRANT SELECT ANY TABLE TO SDE_UPGRADE;
GRANT CREATE OPERATOR TO SDE_UPGRADE;
GRANT CREATE INDEXTYPE TO SDE_UPGRADE;
---- 创建ArcSDE用户sde,密码为
---- 用户使用表空间SPATIAL_MAP_SPACE;临时表空间为SPATIAL_TEMP_SPACE
CREATE USER "SDE" IDENTIFIED BY "密码" DEFAULT TABLESPACE SPATIAL_MAP_SPACE TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
GRANT UNLIMITED TABLESPACE TO SDE;
GRANT SDE_UPGRADE TO SDE;
--创建矢量数据管理用户
CREATE USER "MAP" IDENTIFIED BY "密码" DEFAULT TABLESPACE SPATIAL_MAP_SPACE TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
GRANT UNLIMITED TABLESPACE TO MAP;
GRANT SDE_UPGRADE TO MAP;
--创建栅格数据管理用户
CREATE USER "RASTER" IDENTIFIED BY "密码" DEFAULT TABLESPACE SPATIAL_RASTER_SPACE TEMPORARY TABLESPACE SPATIAL_TEMP_SPACE;
GRANT UNLIMITED TABLESPACE TO RASTER;
GRANT SDE_UPGRADE TO RASTER;
3、修改dbtune表配置信息
导出
sdedbtune -o export -f "c:/dbtune.txt" -i esri_sde -s 服务器名或IP -D 数据库名称 -u sde -p sde密码
导入
sdedbtune -o import -f c:/dbtune.txt -i esri_sde -s 服务器名或IP -D 数据库名称 -u sde -p sde密码
打开c:/dbtune.txt,增加以下内容,添加一个配置关键字MAP。使用该关键时,根据数据类型数据存储到指定的表空间。
##MAP
UI_TEXT "User Interface text description for MAP"
A_INDEX_ROWID "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_STATEID "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_USER "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_XML "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
A_STORAGE "TABLESPACE SPATIAL_MAP_SPACE_S PCTFREE 0 INITRANS 4 NOLOGGING"
AUX_INDEX_COMPOSITE "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
AUX_STORAGE "TABLESPACE SPATIAL_MAP_SPACE_S PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_RASTER "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_ROWID "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_SHAPE "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_TO_DATE "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_USER "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_XML "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
B_STORAGE "TABLESPACE SPATIAL_RASTER_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
BLK_INDEX_COMPOSITE "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
BLK_STORAGE "TABLESPACE SPATIAL_RASTER_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
BND_INDEX_COMPOSITE "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
BND_INDEX_ID "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
BND_STORAGE "TABLESPACE SPATIAL_RASTER_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
D_INDEX_DELETED_AT "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
D_INDEX_STATE_ROWID "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
D_STORAGE "TABLESPACE SPATIAL_MAP_SPACE_S PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_AREA "TABLESPACE SPATIAL_MAP_SPACE_F_I PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_FID "TABLESPACE SPATIAL_MAP_SPACE_F_I PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_LEN "TABLESPACE SPATIAL_MAP_SPACE_F_I PCTFREE 0 INITRANS 4 NOLOGGING"
F_STORAGE "TABLESPACE SPATIAL_MAP_SPACE_F PCTFREE 0 INITRANS 4 NOLOGGING"
LD_INDEX_DATA_ID "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
LD_INDEX_ROWID "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
LD_STORAGE "TABLESPACE SPATIAL_MAP_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
LF_INDEXES "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
LF_STORAGE "TABLESPACE SPATIAL_MAP_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
MVTABLES_MODIFIED_INDEX "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
MVTABLES_MODIFIED_TABLE "TABLESPACE SPATIAL_MAP_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
RAS_INDEX_ID "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
RAS_STORAGE "TABLESPACE SPATIAL_RASTER_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
RDT_INDEX_COMPOSITE "TABLESPACE SPATIAL_RASTER_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
RDT_STORAGE "TABLESPACE SPATIAL_RASTER_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
S_INDEX_ALL "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
S_INDEX_SP_FID "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
S_STORAGE "TABLESPACE SPATIAL_MAP_SPACE_S PCTFREE 0 INITRANS 4 NOLOGGING"
SDO_INDEX_SHAPE "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
SESSION_INDEX "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
SESSION_STORAGE "TABLESPACE SPATIAL_MAP_SPACE_S PCTFREE 0 INITRANS 4 NOLOGGING"
ST_GEOM_LOB_STORAGE "TABLESPACE SPATIAL_MAP_SPACE_S PCTFREE 0 INITRANS 4 NOLOGGING"
STATES_INDEX "TABLESPACE SPATIAL_MAP_SPACE_S_I PCTFREE 0 INITRANS 4 NOLOGGING"
STATES_TABLE "TABLESPACE SPATIAL_MAP_SPACE_S PCTFREE 0 INITRANS 4 NOLOGGING"
VERSIONS_INDEX "TABLESPACE SPATIAL_MAP_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
VERSIONS_TABLE "TABLESPACE SPATIAL_MAP_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
XML_DOC_INDEX "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_DOC_STORAGE "TABLESPACE SPATIAL_XML_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
XML_IDX_INDEX_DOUBLE "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_IDX_INDEX_ID "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_IDX_INDEX_PK "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_IDX_INDEX_STRING "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_IDX_INDEX_TAG "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_IDX_INDEX_TEXT "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_IDX_STORAGE "TABLESPACE SPATIAL_XML_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
XML_INDEX_TAGS_INDEX "TABLESPACE SPATIAL_XML_SPACE_I PCTFREE 0 INITRANS 4 NOLOGGING"
XML_INDEX_TAGS_TABLE "TABLESPACE SPATIAL_XML_SPACE PCTFREE 0 INITRANS 4 NOLOGGING"
END
导入c:/dbtune.txt 后,用catalog连接到SDE点击右键属性打开属性信息,如下图
点击configuration Keywords打开配置关键字信息窗口
第二行就是我们创建的关键字