Windows Server 2019 安装达梦DM8

Windows Server 2019 安装达梦DM8
​

标签（空格分隔）： 达梦系列 ​

一：Windows server 2019 安装DM8

1.1 系统初始化

系统：

Windows server 2019

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

1.2 安装DM8

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

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

打开DM 管理工具

1.3 创建表空间与授权

select * from v$datafile;

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

create user flyfish identified by flyfish123456;

grant dba to flyfish;

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;