在 Oracle 中为检查器工作空间创建数据文件

标准 GIS 存储建议倾向于将索引和日志文件与矢量和表格业务表分开保存。出于性能方面的考虑，最好分开放置业务、要素和空间索引表，并根据表空间数据文件的使用模式对其进行放置。对于多版本化且非常活跃的编辑地理数据库，VERSIONS 表空间的数据库文件可能是分开的并分布于各个可用磁盘中，从而避免出现输入/输出争用情况。

创建新的表空间以存储检查器要素类和表格。

下表列出了要在 SQL 示例中创建的表空间。

TABLESPACE	ArcSDE_PARAMETER
REV_BDATA	业务表
REV_BINDEX	业务表索引
REV_FDATA	要素表
REV_FINDEX	要素表索引
REV_SDATA	空间索引表
REV_SINDEX	空间索引表索引
REV_ADATA	添加表（版本化）
REV_AINDEX	添加表索引
REV_DDATA	删除表（版本化）
REV_DINDEX	删除表索引

检查器工作空间的表空间

注:

对示例进行复制和粘贴可能会导致语法错误。

下列脚本可用于创建使用 Oracle SQL Plus 或 Oracle SQL Developer 的表空间。

ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "revadmin";

CREATE SMALLFILE TABLESPACE "REV_BDATA" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_BDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_BINDEX" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_BINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_FDATA" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_FDATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_FINDEX" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_FINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_SDATA" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_SDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_SINDEX" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_SINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_ADATA" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_ADATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_AINDEX" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_AINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_DDATA" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_DDATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "REV_DINDEX" 
DATAFILE D:\oracle\ORADATA\REVDB\REV_DINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

将数据文件的初始大小设置为 10 MB，以避免在创建表空间时发生延迟。然后，可以重新调整数据文件的大小以避免产生碎片。

ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Bdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Bindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Fdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Findex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Sdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Sindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Adata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Aindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Ddata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\oracle\ORADATA\REVDB\rev_Dindex01.dbf' RESIZE 400M;

可使用 Oracle 企业管理器验证数据文件和表空间。