DM数据库使用

DM数据库使用

标题导入DMP

1.放置input system dir 文件文件
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