Windows Server 2019 安装达梦DM8

标签(空格分隔): 达梦系列 ​

一:Windows server 2019 安装DM8

1.1 系统初始化

系统:

Windows server 2019

将达梦DM8 安装到c盘的DM8下面

1.2 安装DM8

去官网下载x86版本 然后放到ws2019x64虚拟机的ISO 里面

image.png

image.png image.png image.png

image.png

image.png

image.png image.png image.png image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png

image.png image.png

image.png

image.png

安装完成会生成DM的管理工具

image.png

打开DM 管理工具

image.png

image.png image.png

1.3 创建表空间与授权

select * from v$datafile;

image.png

create tablespace flyfishedu datafile 'C:\DM8\data\DAMENG\flyfishedu01.dbf' size 100 autoextend off;

create user flyfish identified by flyfish123456;

grant dba to flyfish;

image.png

image.png

image.png

create table skedu (id int,name varchar(50),create_data date);

insert into skedu values(1,'flyfish1','2021-01-14');
insert into skedu values(2,'flyfish2','2021-01-14');
insert into skedu values(3,'flyfish3','2021-01-14');
insert into skedu values(4,'flyfish4','2021-01-14');
insert into skedu values(5,'flyfish5','2021-01-14');
insert into skedu values(6,'flyfish6','2021-01-14');
insert into skedu values(7,'flyfish7','2021-01-14');
insert into skedu values(8,'flyfish8','2021-01-14');
insert into skedu values(9,'flyfish9','2021-01-14');
insert into skedu values(10,'flyfish10','2021-01-14');


select * from flyfish.skedu;

image.png