-
创建表空间
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;
-
创建SDE用户并授权
--首先创建SDE用户:
CREATE USER SDE IDENTIFIED BY sde
DEFAULT TABLESPACE "SDETABLESPACE"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED ON "SDETABLESPACE";
在Oracle上创建SDE空间库的规范化流程
最新推荐文章于 2025-06-25 11:55:24 发布