05.创建表空间和用户

创建表空间SQL语句如下:-- 创建表空间create tablespace XXGIS                             -- 表空间名datafile 'D:\DATABASE\XXGIS.DBF' size 100M          -- 数据文件位置和初始文件大小autoextend on next 100M maxsize unlimited logging   -- 文件自动扩展大小extent management local autoallocatesegment space management auto;

EXP数据导出命令

IMP数据导入命令

GIS视图修复方法-- 修复GIS视图conn MIS用户/MIS密码@orclGRANT SELECT ON USERINFO TO GIS用户;GRANT SELECT ON ROLEINFO TO GIS用户;GRANT SELECT ON USER_ROLE TO GIS用户;GRANT REFERENCES ON USERINFO TO GIS用户;GRANT REFERENCES ON ROLEINFO TO GIS用户;GRANT SELECT ON EMPLOYEEINFO TO GIS用户;GRANT SELECT ON ORGANIZATIONINFO TO GIS用户;GRANT SELECT ON EMPLOYEE_ORGANIZATION TO GIS用户;GRANT REFERENCES ON EMPLOYEEINFO TO GIS用户;GRANT REFERENCES ON ORGANIZATIONINFO TO GIS用户;GRANT REFERENCES ON EMPLOYEE_ORGANIZATION TO GIS用户;conn GIS用户/GIS密码@orclcreate or replace view userinfo as select * from MIS用户.userinfo;create or replace view roleinfo as select * from MIS用户.roleinfo;create or replace view user_role as select * from MIS用户.user_role;GRANT SELECT ON DATALIST TO MIS用户;GRANT SELECT ON DATAPEMISSIONASSIGN TO MIS用户;GRANT SELECT ON DATAUSERASSIGN TO MIS用户;create or replace view organizationinfo as select * from MIS用户.organizationinfo;create or replace view EMPLOYEEINFO as select * from MIS用户.EMPLOYEEINFO;create or replace view EMPLOYEE_ORGANIZATION as select * from MIS用户.EMPLOYEE_ORGANIZATION;create or replace view UserDept_ViewTrees as select NVL(UserId, DeptId) as UserDeptId, ViewTreeId as ViewTreeId from UserDept_ViewTrees_Table;conn MIS用户/MIS密码@orclcreate or replace view datalist as select * from GIS用户.datalist;create or replace view datapemissionassign as select * from GIS用户.datapemissionassign;create or replace view datauserassign as select * from GIS用户.datauserassign;