- 浏览: 1781896 次
- 性别:
- 来自: 成都
-
文章分类
- 全部博客 (520)
- Oracle (10)
- Oracle错误集 (8)
- Oracle安装升级 (15)
- Oracle日常管理 (51)
- Oracle字符集 (7)
- Oracle备份恢复 (24)
- Oracle优化 (4)
- Oracle编程 (52)
- Oracle导入导出 (19)
- Oracle体系结构 (15)
- Oracle网络 (2)
- Oracle安全 (2)
- Oracle权限 (3)
- Oracle数据字典和性能视图 (2)
- Oracle常用地址 (5)
- SQLPLUS专栏 (7)
- SqlServer (13)
- SqlServer2005编程 (27)
- SqlServer2005管理 (15)
- MySQL (20)
- Dorado应用 (1)
- C# (24)
- Arcgis Server开发 (20)
- ArcSDE技术 (19)
- UML学习 (2)
- 设计模式 (2)
- JAVA EE (4)
- JavaScript (3)
- OFBIZ (27)
- JAVA WEB开发 (22)
- Linux&Unix (34)
- SHELL编程 (14)
- C语言 (11)
- 网络协议 (14)
- FREEMARKER (2)
- GROOVY (2)
- JAVA语言 (3)
- 防火墙 (0)
- PHP (2)
- Apache (2)
- Loader Runner (1)
- Nginx (3)
- 数据库理论 (2)
- maven (1)
最新评论
-
怼怼怼怼:
oracle的timestamp类型使用 -
怼怼怼怼:
oracle的timestamp类型使用 -
怼怼怼怼:
oracle的timestamp类型使用 -
pg_guo:
感谢
oracle中查看用户权限 -
xu234234:
5、MapResourceManager控件中添加了两个服务, ...
北京ArcGis Server应用基础培训笔记1
一、创建表空间
create tablespace gis_data datafile '%oracle_base%\oradata\acf\gis_data_01.dbf' size 301m uniform size 128k;
create tablespace versioned_data datafile '%oracle_base%\oradata\acf\versioned_data_01.dbf' size 101m uniform size 4M;
二、创建用户并授权
create user gisadmin identified by gisadmin default tablespace gis_data;
grant create session,create procedure,create table,create sequence,create trigger to gisadmin;
alter user gisadmin quota unlimited on gis_data;
alter user gisadmin quota unlimited on versioned_data;
三、导出dbtune表内容
sdedbtune -o export -f c:\dbtune_ex07.sde -u sde -p sde
四、往导出的文件中添加如下参数
GEOMETRY_STORAGE "SDEOLB"
ATTRIBUTE_BINARY "BOLB"
UI_TEXT "USER INTERFACE TEXT"
B_INDEX_ROWID "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_SHAPE "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
B_INDEX_USER "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
B_STORAGE "TABLESPACE gis_data PCTFREE 0 INITRANS 4"
F_INDEX_AREA "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_FID "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_LEN "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
F_STORAGE "TABLESPACE gis_data PCTFREE 0 INITRANS 4"
S_INDEX_ALL "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
S_INDEX_SP_FID "TABLESPACE gis_data PCTFREE 0 INITRANS 4 NOLOGGING"
S_STORAGE "TABLESPACE gis_data PCTFREE 0 INITRANS 4"
A_INDEX_ROWID "TABLESPACE versioned_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_SHAPE "TABLESPACE versioned_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_STATEID "TABLESPACE versioned_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_USER "TABLESPACE versioned_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_INDEX_XML "TABLESPACE versioned_data PCTFREE 0 INITRANS 4 NOLOGGING"
A_STORAGE "TABLESPACE versioned_data PCTFREE 0 INITRANS 4"
D_INDEX_DELETED_AT "TABLESPACE versioned_data PCTFREE 0 INITRANS 4 NOLOGGING"
D_INDEX_STATE_ROWID "TABLESPACE versioned_data PCTFREE 0 INITRANS 4 NOLOGGING"
D_STORAGE "TABLESPACE versioned_data PCTFREE 0 INITRANS 4"
END
5、保存后,导入dbtune表的内容
sdedbtune -o import -f c:\dbtune_ex07.sde -u sde -p sde
6、导入数据即可
发表评论
-
SDE用户权限脚本
2008-07-14 13:44 3577DROP ROLE SDE_UPGRADE;CREATE RO ... -
ArcSDE/Oracle的简单优化(图层和索引分开)
2008-07-10 10:01 27631.SDE的性能主要还是取决于Oracle的性能,然后才是SD ... -
ArcSDE的版本管理机制
2008-07-07 15:10 2709版本是SDE数据库中管理数据的一种机制,主要解决长事务问题。 ... -
ArcSDE栅格数据的存储结构
2008-07-07 13:19 2278一个元数据表:SDE_raster_columns 一个业务 ... -
Raster dataset schema overview
2008-07-07 10:51 14471、Business table 2、AUX table:St ... -
常用命令
2008-07-07 10:41 14341、sdetable 查看表的关系 eg. sdet ... -
Manage raster storage
2008-07-07 09:37 1103一、创建表空间create tablespace versio ... -
SDE中的表
2008-07-04 09:25 25131、B表:属性表 2、F表:要素表 3、S表:索引表 4、A表 ... -
SDE三种连接方式
2008-07-03 14:57 2655一、Application server connection ... -
Operating multiple geodatabases
2008-07-03 14:15 1449Creating multiple geodatabases ... -
Using multiple geodatabases within a DBMS
2008-07-03 13:46 3634Each database management system ... -
基于Geodatabase数据模型的版本机制
2008-07-03 11:32 1749一、版本是什么?(What is Version?) “版本” ... -
arcsde9.2和oracle分布式安装
2008-07-02 11:18 2710环境: oracle10gR2安装在两台服务器上,但只是做双机 ... -
创建多个ArcSDE实例
2008-07-02 09:29 2732有时候,我们需要有多于一个的ArcSDE实例同时运行。只要存在 ... -
SDE命令行安装配置
2008-07-01 16:34 3439一、创建相关表空间 创建sde表空间 create table ... -
oracle for sde配置
2008-06-30 15:40 22011、修改oracle系统参数alter system set ... -
ArcSDE空间数据库中SDE用户使用探讨
2008-06-30 15:26 3129ArcSDE作为空间数据库解决方案,应用非常广泛,本短文将尝试 ... -
创建多个ArcSDE实例
2008-06-23 19:42 2145有时候,我们需要有多 ...
相关推荐
在C++中,虽然引入了智能指针和内存管理容器如`std::vector`、`std::string`等,但理解C语言的内存管理机制仍然是必要的,因为这有助于编写高效且健壮的代码,并能更好地理解和解决C++中的内存问题。 总结,`C_...
PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to ...
PostGIS is a spatial database that integrates advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the ...
Chapter 4, Data Types, Storage, and Conversion, focuses on the many different data types (both vector and raster) that exist within GIS. Chapter 5, Vector Data Analysis, covers Python libraries such ...
It provides robust data storage and retrieval capabilities using Data Definition Language (DDL) and Data Manipulation Language (DML). Oracle databases are widely used in various industries for ...
4. **Windows CardSpace:** This is a digital identity management system that allows users to manage their digital identities securely and easily. ### AJAX/ATLAS AJAX (Asynchronous JavaScript and XML)...
The goal of this guide is to manage this complexity by describing in detail the dos and don'ts of writing C++ code. These rules exist to keep the code base manageable while still allowing coders to ...