oracle sde 千万数据,Oracle+sde数据备份恢复（转自GIS帝国论坛）

1.数据库完整备份

EXP SYSTEM/PASSWORD@SID FULL=Y FILE=D:\SYSTEM.DMP LOG=D:\SYSTEM.LOG

2.数据入库

(a)从数据库中删除SDE和SDE USER用户

DROP USER SDE CASCADE;

DROP USER SDEUSER CASCADE;

(b)创建新的SDE用户和SDEUSER

下为创建SDE用户过程:

(i)创建表空间

CREATE TABLESPACE "SDE"

LOGGING

DATAFILE 'C:\ORACLE\ORADATA\ORACLE\SDE.ora' SIZE 200M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO

(ii)创建用户

CREATE USER "SDE"  PROFILE "DEFAULT"

IDENTIFIED BY "PASSWORD" DEFAULT TABLESPACE "SDE"

TEMPORARY TABLESPACE "TEMP"

ACCOUNT UNLOCK;

(iii)创建角色

GRANT "DBA" TO "SDE";

GRANT "CONNECT" TO "SDE";

GRANT "RESOURCE" TO "SDE";

(iiii)系统权限

GRANT ALTER ANY INDEX TO "SDE" WITH ADMIN OPTION;

GRANT ALTER ANY TABLE TO "SDE" WITH ADMIN OPTION;

GRANT ANALYZE ANY TO "SDE" WITH ADMIN OPTION;

GRANT CREATE ANY INDEX TO "SDE" WITH ADMIN OPTION;

GRANT CREATE ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;

GRANT CREATE ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;

GRANT CREATE ANY TRIGGER TO "SDE" WITH ADMIN OPTION;

GRANT CREATE ANY VIEW TO "SDE" WITH ADMIN OPTION;

GRANT CREATE SESSION TO "SDE" WITH ADMIN OPTION;

GRANT DROP ANY INDEX TO "SDE" WITH ADMIN OPTION;

GRANT DROP ANY TABLE TO "SDE" WITH ADMIN OPTION;

GRANT DROP ANY VIEW TO "SDE" WITH ADMIN OPTION;

GRANT DROP ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;

GRANT DROP ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;

GRANT EXECUTE ANY PROCEDURE TO "SDE" WITH ADMIN OPTION;

GRANT SELECT ANY SEQUENCE TO "SDE" WITH ADMIN OPTION;

GRANT SELECT ANY TABLE TO "SDE" WITH ADMIN OPTION;

GRANT UNLIMITED TABLESPACE  TO "SDE" WITH ADMIN OPTION;

3.导入SDE和SDEUSER的数据

注意顺序，先SDE，后SDEUSER

IMP SYSTEM/PASSWOR@SID FROMUSER=SDE TOUSER=SDE

IMP SYSTEM/PASSWOR@SID FROMUSER=SDEUSER TOUSER=SDEUSER

以上提到的SDE和SDEUSER是不同的用户，SDE是ArcSDE安装时的默认用户，SDEUSER

是指用户存储数据的用户，如果之间使用SDE默认用户存储，则省去所以的SDEUSER操作

注：如果移植后arcSDE服务无法启动，则进入post installation重新设置一下arcSDE服务。