查看达梦版本

--查看版本

[dmdba@ncdb2 ~]$ disql SYSDBA/randompwd

服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 3.395(ms)
disql V8
SQL> select * from v$version;

行号 BANNER
---------- ---------------------------------
1 DM Database Server 64 V8
2 DB Version: 0x7000c
3 03134284294-20240919-243448-20119
4 Msg Version: 21
5 Gsu level(5) cnt: 0

已用时间: 1.244(毫秒). 执行号:501.
SQL> select id_code;

行号 id_code
---------- -----------------------------------------
1 --03134284294-20240919-243448-20119 Pack1

已用时间: 1.374(毫秒). 执行号:502.

-- 新版本使用
SELECT REGEXP_SUBSTR(ID_CODE, '[^-]+', 1, 2) AS 日期,
TO_NUMBER(SUBSTR(VER,1,2),'XX')||'.'||
TO_NUMBER(SUBSTR(VER,3,2),'XX')||'.'||
TO_NUMBER(SUBSTR(VER,5,2),'XX')||'.'||
TO_NUMBER(SUBSTR(VER,7,2),'XX')||
CASE
WHEN PACK_POS > 0 THEN ' ' || SUBSTR(ID_CODE,INSTR(ID_CODE,' ') + 1)
ELSE ''
END AS 版本号,
BUILD_TYPE AS 版本类型
FROM (SELECT DECODE(SUBSTR(VER,1,2),'03','企业版','05','安全版','02','标准版','其他') AS BUILD_TYPE
,RAWTOHEX(CAST(SUBSTR(VER,3) AS INT)) AS VER, INSTR(ID_CODE,' ') PACK_POS
FROM (SELECT REGEXP_SUBSTR(ID_CODE,'[^-]+',1,1) AS VER)
);

--查看数据库实例相关

SELECT '实例名称' 数据库选项,INSTANCE_NAME 数据库集群相关参数值 FROM V$INSTANCE UNION ALL
SELECT '数据库名',CUR_DATABASE()FROM DUAL UNION ALL
SELECT '授权客户',(SELECT AUTHORIZED_CUSTOMER FROM V$LICENSE) UNION ALL
SELECT '数据库授权码',(SELECT SERIES_NO FROM V$LICENSE) UNION ALL
SELECT '数据库有效期',CAST((SELECT EXPIRED_DATE FROM V$LICENSE)AS VARCHAR) UNION ALL
SELECT '数据库版本',SUBSTR(SVR_VERSION,INSTR(SVR_VERSION,'(')) FROM V$INSTANCE UNION ALL
SELECT '数据库版本小号',(SELECT BUILD_VERSION FROM V$INSTANCE) UNION ALL
SELECT '数据库实例路径',(SELECT PARA_VALUE FROM V$DM_INI WHERE PARA_NAME LIKE'%SYSTEM_PATH%') FROM V$INSTANCE UNION ALL
SELECT '数据库模式',MODE$ FROM V$INSTANCE UNION ALL
SELECT '数据库状态',STATUS$ FROM V$INSTANCE UNION ALL
SELECT 'OGUID',CAST(OGUID AS VARCHAR) FROM V$INSTANCE UNION ALL
SELECT '归档状态_开 Y/关 N',ARCH_MODE FROM V$DATABASE UNION ALL
SELECT '长度是否以字符为单位',CASE (SELECT PARA_VALUE FROM V$DM_INI WHERE "V$DM_INI".PARA_NAME ='LENGTH_IN_CHAR') WHEN '0' THEN '否' WHEN '1' THEN '是' END UNION ALL
SELECT '大小写是否敏感_是 Y,1/否N,0',CAST(SF_GET_CASE_SENSITIVE_FLAG() AS VARCHAR) UNION ALL
SELECT '字符集',CASE SF_GET_UNICODE_FLAG() WHEN '0' THEN 'GBK18030' WHEN '1' THEN 'UTF-8' WHEN '2' THEN 'EUC-KR' END UNION ALL
SELECT '页大小',CAST(PAGE()/1024 AS VARCHAR) UNION ALL
SELECT '簇大小',CAST(SF_GET_EXTENT_SIZE() AS VARCHAR) UNION ALL
SELECT '唯一魔数',CAST(PERMANENT_MAGIC AS VARCHAR) UNION ALL
SELECT 'LSN',CAST(CUR_LSN AS VARCHAR) FROM V$RLOG UNION ALL
SELECT '当前登录用户',USER;

--查看达梦dexp dimp帮助

dimp help dexp help

--查看用户和schema

select a.name as username, b.name as schenma from sysobjects a inner join sysobjects b on a.id = b.pid where b.subtype$ is null order by username desc;