在Oracle上创建SDE空间库的规范化流程

1. 创建表空间

   CREATE TABLESPACE sdetablespace DATAFILE

   'C:\APP\ADMINISTRATOR\ORADATA\ORCL\SDEDATA01.DBF' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED

   LOGGING

   EXTENT MANAGEMENT LOCAL AUTOALLOCATE

   BLOCKSIZE 8K

   SEGMENT SPACE MANAGEMENT AUTO

   FLASHBACK ON;

2. 创建SDE用户并授权

   --首先创建SDE用户：

   CREATE USER SDE IDENTIFIED BY sde

   DEFAULT TABLESPACE "SDETABLESPACE"

   TEMPORARY TABLESPACE "TEMP"

   QUOTA UNLIMITED ON "SDETABLESPACE";