`

Manage vector storage

阅读更多

一、创建表空间
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、导入数据即可

 

分享到:
评论

相关推荐

    C_memory_manage.zip_memory

    在C++中,虽然引入了智能指针和内存管理容器如`std::vector`、`std::string`等,但理解C语言的内存管理机制仍然是必要的,因为这有助于编写高效且健壮的代码,并能更好地理解和解决C++中的内存问题。 总结,`C_...

    PostGIS cookbook

    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 Cookbook.pdf

    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 ...

    Mastering.Geospatial.Analysis.with.Python

    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 ...

    java英文笔试

    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 ...

    SampleDotNetInterviewQuestionBook

    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)...

    Google C++ Style Guide(Google C++编程规范)高清PDF

    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 ...

Global site tag (gtag.js) - Google Analytics