1,登录命令行
su - dmdba
disql SYSDBA/'"SYSDBA"' @192.168.56.12:5236
2 查看达梦版本
SQL > select * from v$version;
行号 BANNER
1 DM Database Server 64 V8
2 DB Version: 0x7000c
3,创建用户,授权,查看schema ,用户下的表名,建表语句
create user user1 identified by "user1#123" ;
grant PUBLIC to user1;
grant RESOURCE to user1;
grant SOI to user1;
alter user userTest identified by 123456 ;
GRANT ALL PRIVILEGES ON user2. xxx TO user1;
select owner, table_name, tablespace_name, status from dba_tables;
SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNER IN ( 'user1' ) ;
set SCHEMA schemaXXX;
select table_name from user_tables;
SELECT TABLE_NAME, OWNER FROM ALL_TABLES ORDER BY OWNER, TABLE_NAME;
alter table table1 add msg VARCHAR ( 128 ) default '' ;
alter table table1 modify msg text default '' ;
alter table table1 rename to table11;
create table table1bak as select * from table1;
call SP_TABLEDEF( 'DBName' , 'TAble_name' ) ;
SELECT * FROM V$SESSIONS WHERE SQL_TEXT LIKE '%tabname%' ;
SP_CLOSE_SESSION( 281458835200952 ) ;
start / tmp/ a. sql
set char_code utf8;
set define off ;
4,达梦数据库导入导出: 参考安装目录下的 dmdbms\doc\DM8_dexp和dimp使用手册.pdf
dexp 模式名/密码@192.168.X.X:5236 file = 模式名 directory = D:\ DB\ owner = 模式名
dexp SYSDBA/SYSDBA GRANTS = Y TABLES = ( SYSDBA.TAB1,SYSDBA.TAB2,SYSDBA.TAB3)
dexp wang/'"wangwang@123"' @192.168.56.12:5236 file = wang directory = /tmp/ owner = wang
dimp 模式名/密码 file = /tmp/xxx user = 模式名
dimp wang/'"wangwang@123"' @192.168.56.12:5236 file = wang directory = /tmp 覆盖导入参数:PRIMARY_CONFLICT= OVERWRITE IGNORE = Y
5,达梦–安装管理
[ dmdba@db02 dmdbms] $ ps -ef | grep dm*
dmdba 782710 1 0 7 月12 ? 00:59:39 /home/dmdba/dmdbms/bin/dmwatcher path = /data/dmdb/dmwatcher.ini
dmdba 861042 1 0 7 月13 ? 14 :30:59 /home/dmdba/dmdbms/bin/dmserver path = /data/dmdb/dm.ini -noconsole
dmdba 3220244 3219036 0 17 :09 pts/0 00:00:00 grep dmdbms
[ dmdba@db02 dmdbms] $ pwd
/home/dmdba/dmdbms
[ dmdba@db02 dmdbms] $ ./bin/DmServiceDM
Usage: ./bin/DmServiceDM { start [ mount ] | stop [ -s signal ] | stop_all | status | condrestart | restart [ mount ] }
[ dmdba@db02 dmdbms] $ ./bin/DmServiceDM status
DmServiceDM ( pid 861042 ) is running.
[ dmdba@db02 dmdbms] $
systemctl status DmServiceDM
systemctl status DmWatcherServiceDM
[ dmdba@db02 dmdbms] $ dmserver /data/dmdb/dm.ini