达梦 DM8 DCP 备考笔记-- 分区表操作.docx

itsanrx

136

15页

3次

2023-03-24

5墨值下载

达梦

DM8 DCP

备考笔记

分区表操作

DCP

考试中的相关操作可以通过命令行进行，也可以通过工具进行界面操作。

我们这里记录命令行的操作过程。

初始化实例

我这里准备了

台虚拟机，

地址信息如下：

[root@dcp1 ~]# cat /etc/hosts

127.0.0.1 localhost

192.168.56.102 dcp1

192.168.56.103 dcp2

192.168.56.104 dcp3

102

和

103

主备库，

104

做监视器节点。所以这里在操作之前现在

102

和

103

上创建初始化的实例。

[dmdba@dcp1 software]$ dminit PATH=/dm/dmdbms/data DB_NAME=DCP

INSTANCE_NAME=DCP SYSDBA_PWD=dameng123 SYSAUDITOR_PWD=dameng123

page_size=32 extent_size=32 length_in_char=1 LOG_SIZE=256

CASE_SENSITIVE=Y CHARSET=1 PORT_NUM=5236

initdb V8

db version: 0x7000c

file dm.key not found, use default license!

License will expire on 2023-05-25

Normal of FAST

Normal of DEFAULT

Normal of RECYCLE

Normal of KEEP

Normal of ROLL

log file path: /dm/dmdbms/data/DCP/DCP01.log

log file path: /dm/dmdbms/data/DCP/DCP02.log

write to dir [/dm/dmdbms/data/DCP].

create dm database success. 2022-10-27 23:28:27

用

root

用户注册服务：

[root@dcp1 root]#./dm_service_installer.sh -t dmserver -dm_ini

/dm/dmdbms/data/DCP/dm.ini -p dcp

Created symlink from /etc/systemd/system/multi-

user.target.wants/DmServicedcp.service to

/usr/lib/systemd/system/DmServicedcp.service.

Finished to create the service (DmServicedcp)

[root@dcp1 root]#

创建水平分区表

2.1

创建用户和表空间

[dmdba@dcp1 DCP]$ disql SYSDBA/dameng123

Server[LOCALHOST:5236]:mode is normal, state is open

disql V8

SQL> create tablespace CNDBA1 DATAFILE

'/dm/dmdbms/data/DCP/CNDBA1_01.dbf' size 128;

executed successfully

used time: 25.888(ms). Execute id is 55300.

SQL> create tablespace CNDBA2 DATAFILE

'/dm/dmdbms/data/DCP/CNDBA2_01.dbf' size 128;

executed successfully

used time: 26.555(ms). Execute id is 55301.

SQL> create tablespace CNDBA3 DATAFILE

'/dm/dmdbms/data/DCP/CNDBA3_01.dbf' size 128;

executed successfully

used time: 39.750(ms). Execute id is 55302.

SQL> create tablespace CNDBA4 DATAFILE

'/dm/dmdbms/data/DCP/CNDBA4_01.dbf' size 128;

executed successfully

used time: 38.049(ms). Execute id is 55303.

SQL> create user CNDBA identified by dameng123 default tablespace

CNDBA1;

executed successfully

used time: 4.349(ms). Execute id is 55304.

SQL> grant public,resource,dba to cndba;

executed successfully

used time: 3.058(ms). Execute id is 55305.

SQL>

2.2

创建范围分区表

create

table CNDBA."T1"

(

"ID" INT,

"NAME" VARCHAR(20)

)

PARTITION BY RANGE

(

"ID"

)

(

PARTITION "P1" VALUES LESS THAN (100) STORAGE( initial 1,

next 1, minextents 1, fillfactor 0, on "CNDBA1"),

PARTITION "P2" VALUES LESS THAN (200) STORAGE( initial 1,

next 1, minextents 1, fillfactor 0, on "CNDBA2"),

PARTITION "P3" VALUES LESS THAN (300) STORAGE( initial 1,

next 1, minextents 1, fillfactor 0, on "CNDBA3"),

PARTITION "PN" VALUES LESS THAN (MAXVALUE) STORAGE( initial

1, next 1, minextents 1, fillfactor 0, on "CNDBA4")

)

storage

(

of 15

5墨值下载

达梦 dm8 dcp

关注

评论