DM（达梦数据库导入dmp）

来源：互联网发布：卖家如何找淘宝客推广编辑：程序博客网时间：2024/05/30 05:14

1.input system dir 文件文件随意放：注意不要放在 C 盘

2.注册服务

3。 SYSDBA(默认密码：SYSDBA) 登入创建用户

create tablespace "ISSUSR" datafile 'E:\dmdbms\data\ISS\ISSUSR.dbf' size 256 autoextend on next 256 CACHE = NORMAL;

/* 以SYSDBA身份创建用户 */

create user "ISSUSR" identified by "ISSUSR_USER" default tablespace "ISSUSR";

/* 用户授权 */

grant "RESOURCE" to "ISSUSR" ;

grant CREATE TABLE,CREATE VIEW,CREATE PROCEDURE,CREATE SEQUENCE,CREATE TRIGGER,CREATE INDEX,CREATE CONTEXT INDEX ,BACKUP DATABASE,CREATE LINK,CREATE REPLICATE,CREATE PACKAGE,CREATE SYNONYM,CREATE PUBLIC SYNONYM,ALTER REPLICATE,DROP REPLICATE,CREATE ANY TABLE, ALTER ANY TABLE,DROP ANY TABLE, INSERT TABLE ,INSERT ANY TABLE ,UPDATE TABLE,UPDATE ANY TABLE ,DELETE TABLE,DELETE ANY TABLE, SELECT TABLE ,SELECT ANY TABLE,REFERENCES TABLE,REFERENCES ANY TABLE ,GRANT TABLE,GRANT ANY TABLE,CREATE ANY VIEW, ALTER ANY VIEW,DROP ANY VIEW ,INSERT VIEW,INSERT ANY VIEW ,UPDATE VIEW,UPDATE ANY VIEW, DELETE VIEW ,DELETE ANY VIEW ,SELECT VIEW,SELECT ANY VIEW, GRANT VIEW ,GRANT ANY VIEW ,CREATE ANY PROCEDURE ,DROP ANY PROCEDURE ,EXECUTE PROCEDURE,EXECUTE ANY PROCEDURE, GRANT PROCEDURE,GRANT ANY PROCEDURE, CREATE ANY SEQUENCE,DROP ANY SEQUENCE,SELECT SEQUENCE,SELECT ANY SEQUENCE ,GRANT SEQUENCE,GRANT ANY SEQUENCE,CREATE ANY TRIGGER, DROP ANY TRIGGER,CREATE ANY INDEX ,ALTER ANY INDEX,DROP ANY INDEX, CREATE ANY CONTEXT INDEX, ALTER ANY CONTEXT INDEX,DROP ANY CONTEXT INDEX,CREATE ANY PACKAGE, DROP ANY PACKAGE,EXECUTE PACKAGE,EXECUTE ANY PACKAGE, GRANT PACKAGE ,GRANT ANY PACKAGE ,CREATE ANY LINK,DROP ANY LINK, CREATE ANY SYNONYM,DROP ANY SYNONYM ,DROP PUBLIC SYNONYM,SELECT ANY DICTIONARY,ALTER ANY TRIGGER, CREATE MATERIALIZED VIEW,CREATE ANY MATERIALIZED VIEW,DROP ANY MATERIALIZED VIEW,ALTER ANY MATERIALIZED VIEW ,SELECT MATERIALIZED VIEW ,SELECT ANY MATERIALIZED VIEW,CREATE ANY CONTEXT, DROP ANY CONTEXT,GRANT ANY CONTEXT ,COMMENT ANY TABLE,DUMP ANY TABLE,DUMP TABLE to "ISSUSR";

/* ========================================== 配置作业管理系统 ========================================== */

/* 在DM7的作业管理系统中，要进行作业管理，首先需要一些表来存储作业相关的对象、历史记录等信息。*/

/* 这些表有SYSJOBS、SYSJOBSTEPS、SYSJOBSCHEDULES、SYSMAILINFO、SYSJOBHISTORIES、SYSALERTHISTORIES、SYSOPERATORS、SYSALERTS、SYSALERTNOTIFICATIONS。*/

/* 用户可以通过调用系统过程SP_INIT_JOB_SYS()来创建这些表。这些表被建在SYSJOB模式下。*/

/* 创建SYSJOB模式及9张表的语句：*/

SP_INIT_JOB_SYS(1);

4.用户创建好的用户 ISSUSR 登入

5. 导入开始

6：切记：导入表空间一定要和DMP表空间一样

详情访问：http://app.yinxiang.com/l/ACafPJY0fEpGaL0FmkMvtSaYpXFoMssl3S4/

0 0