操作方法
本文介绍使用 Data Pump 导入实用程序 (impdp) 按方案导入 Oracle Data Pump 文件时要执行的一系列步骤。 这些步骤一次运行一个。
支持版本:
sqlplus sys/syspassword@server/sid as sysdba
GRANT EXECUTE ON dbms_pipe TO public; GRANT EXECUTE ON dbms_lock TO public; GRANT EXECUTE ON dbms_lob TO public; GRANT EXECUTE ON dbms_utility TO public; GRANT EXECUTE ON dbms_sql TO public; GRANT EXECUTE ON utl_raw TO public;
select distinct owner from sde.layers union select distinct owner from sde.st_geometry_columns union select distinct owner from sde.table_registry order by 1;
注: 这是一个自动扩展的默认表空间。
CREATE TABLESPACE SDETBS DATAFILE '/home/oracle/orcl/oradata/banner/sde.dbf' SIZE 100M AUTOEXTEND ON NEXT 51200K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 320K LOGGING ONLINE SEGMENT SPACE MANAGEMENT MANUAL;
create user sde identified by sdepassword default tablespace sdetbs;
grant CREATE SESSION to sde; grant CREATE TABLE to sde; grant CREATE TRIGGER to sde; grant CREATE SEQUENCE to sde; grant CREATE PROCEDURE to sde; grant EXECUTE ON DBMS_CRYPTO to sde; grant CREATE INDEXTYPE to sde; grant CREATE LIBRARY to sde; grant CREATE OPERATOR to sde; grant CREATE PUBLIC SYNONYM to sde; grant CREATE TYPE to sde; grant CREATE VIEW to sde; grant DROP PUBLIC SYNONYM to sde; grant ADMINISTER DATABASE TRIGGER to sde; grant ALTER ANY INDEX to sde; grant ALTER ANY TABLE to sde; grant CREATE ANY INDEX to sde; grant CREATE ANY TRIGGER to sde; grant CREATE ANY VIEW to sde; grant DROP ANY INDEX to sde; grant DROP ANY VIEW to sde; grant SELECT ANY TABLE to sde; grant ALTER SESSION to sde; grant ANALYZE ANY to sde; grant SELECT ANY DICTIONARY to sde; grant CREATE DATABASE LINK to sde; grant CREATE MATERIALIZED VIEW to sde; grant RESTRICTED SESSION to sde; grant UNLIMITED TABLESPACE to sde; grant ALTER SYSTEM to sde; grant SELECT_CATALOG_ROLE to sde;
create directory DPUMP1 as '/home/oracle/dpump';
GRANT READ, WRITE ON DIRECTORY DPUMP1 to system; exit
impdp system/sys directory=dpump1 logfile=sde_imp.log dumpfile=backup.DMP schemas=sde
impdp system/sys directory=dpump1 logfile=GIS_imp.log dumpfile=backup.DMP schemas=GIS
sqlplus sys/sys@server/sid as sysdba Select count(*) from dba_objects where owner='SDE' and status='INVALID';
exec dbms_utility.compile_schema(schema => 'SDE');
从 ArcGIS 专家处获得帮助
下载 Esri 支持应用程序