支持国产数据库，达梦数据库试用团DM7大体验，优缺点我来评！活动结束，获奖名单公布

zchzgs

支持的哦

pumpking6

速度太慢了

xiehuanzhong

我在windows xp上安装的DM7在创建数据库环节，提示‘创建数据库失败’，与157楼出现同样的问题。还望lz给予解决方案。

myth8860

xiehuanzhong 发表于 2011-12-10 22:42
我在windows xp上安装的DM7在创建数据库环节，提示‘创建数据库失败’，与157楼出现同样的问题。还望lz给予 ...

可能是修改密码的时候密码少于6位数导致的，可以用dbca工具再建一次库，密码设长一点。

myth8860

pangzi913 发表于 2011-12-9 13:50
第一次安装达梦失败了。

感受佳：1、安装文件小。  原因：***  辅助说明：***

修改的口令要大于等于6位数，您再初始化一遍试试

hwtong

对的 建立数据库的时候提示的密码必须多于6位..

xiehuanzhong

的确是密码过短的原因，现在能够创建成功了，但是这个为什么在创建数据库的时候应该给予提示就好了。

〇〇

一些测试

1. 
   
2. ------------dm6------------
   
3. SQL>desc dual;
   
4. desc dual;
   
5. 
   
6.         COLNAME         TYPE            LENGTH          NULLABLE
   
7. 0 rows got
   
8. time used: 0.646(ms).
   
9. SQL>select * from dual connect by level<3;
   
10. select * from dual connect by level<3;
    
11. 
    
12. 用户数据中的CONNECT BY循环.error code = -1831
    
13. SQL>select * from dual connect by rownum<3;
    
14. select * from dual connect by rownum<3;
    
15. 
    
16. 用户数据中的CONNECT BY循环.error code = -1831
    
17. ------------dm7------------
    
18. 
    
19. SQL>select * from dual connect by level<3;
    
20. select * from dual connect by level<3;
    
21. 
    
22. 无效的CONNECT BY子句.error code=-4033
    
23. SQL>
    
24. SQL>select * from dual connect by rownum<3;
    
25. select * from dual connect by rownum<3;
    
26. 
    
27. 第 1 行附近出现错误:
    
28. 表达式中不允许包含ROWNUM.error code=-3705
    
29. 
    
30. SQL>select * from dual connect by prior id=id;
    
31. select * from dual connect by prior id=id;
    
32. 
    
33. 用户数据中的CONNECT BY循环.error code=-4030
    
34. 
    
35. SQL>create tablespace ts datafile 'D:\dmdbms\data\DAMENG\ts.dbf' size 2G;
    
36. create tablespace ts datafile 'D:\dmdbms\data\DAMENG\ts.dbf' size 2G;
    
37. 
    
38. 第 1 行, 第 67 列[G]附近出现错误:
    
39. 语法分析出错.error code=-2007
    
40. SQL>create tablespace ts datafile 'D:\dmdbms\data\DAMENG\ts.dbf' size 2048;
    
41. time used: 18.445(ms) clock tick:30904337. Execute id is 300.
    
42. SQL>create user t identified by t default tablespace ts;
    
43. create user t identified by t default tablespace ts;
    
44. 
    
45. 第 1 行附近出现错误:
    
46. 密码长度不符合要求(6到48个字节).error code=-2504
    
47. SQL>create user t identified by t12345 default tablespace ts;
    
48. create user t identified by t12345 default tablespace ts;
    
49. 
    
50. time used: 7.233(ms) clock tick:12115446. Execute id is 301.
    
51. SQL>grant dba to t;
    
52. grant dba to t;
    
53. 
    
54. time used: 2.538(ms) clock tick:4243962. Execute id is 302.
    
55. SQL>login
    
56. server:localhost
    
57. user name:t
    
58. password:
    
59. port:
    
60. 用户名或密码错误.error code=-2501
    
61. SQL>login
    
62. server:localhost
    
63. user name:T
    
64. password:
    
65. port:
    
66. login time used:4.956(ms)
    
67. 服务器[localhost]:处于普通打开状态
    
68. SQL>create table t(c int);
    
69. create table t(c int);
    
70. 
    
71. time used: 16.131(ms) clock tick:27030390. Execute id is 303.
    
72. SQL>insert into t select 1 union select 2 ;
    
73. insert into t select 1 union select 2 ;
    
74. 
    
75. 2 rows affected
    
76. time used: 81.001(ms) clock tick:135757913. Execute id is 304.
    
77. SQL>desc t
    
78. 2   ;
    
79. COLNAME         TYPE            LENGTH          NULLABLE
    
80. 
    
81. 1       C       INT     4               Y
    
82. 1 rows got
    
83. time used: 15.391(ms) clock tick:25785687. Execute id is 305.
    
84. SQL>create table big as select rownum rn from t,t,t,t,t,t,t,t,t,t,t,t,t;
    
85. create table big as select rownum rn from t,t,t,t,t,t,t,t,t,t,t,t,t;
    
86. 
    
87. 第 1 行附近出现错误:
    
88. 重复的表名或别名[T].error code=-2194
    
89. SQL>create table big as select rownum rn from t,t t1,t t2,t t3,t t4,t t5,t t6,t t7,t t8,t t9,t t10,t t11,t t12;
    
90. create table big as select rownum rn from t,t t1,t t2,t t3,t t4,t t5,t t6,t t7,t t8,t t9,t t10,t t11,t t12;
    
91. 
    
92. time used: 24.588(ms) clock tick:41194768. Execute id is 306.
    
93. SQL>select count(*) from big;
    
94. select count(*) from big;
    
95. COUNT(*)
    
96. 
    
97. 1       8192
    
98. 1 rows got
    
99. time used: 1.085(ms) clock tick:1809108. Execute id is 307.
    
100. SQL>create t1m as select top 1000000 rownum c from big,big t1;
     
101. create t1m as select top 1000000 rownum c from big,big t1;
     
102. 
     
103. 第 1 行, 第 7 列[t1m]附近出现错误:
     
104. 语法分析出错.error code=-2007
     
105. SQL>create t1m as select top  rownum c from big,big t1 where rownum<=1000000;
     
106. create t1m as select top  rownum c from big,big t1 where rownum<=1000000;
     
107. 
     
108. 第 1 行, 第 7 列[t1m]附近出现错误:
     
109. 语法分析出错.error code=-2007
     
110. SQL>create t1m as select rownum c from big,big t1 where rownum<=1000000;
     
111. create t1m as select rownum c from big,big t1 where rownum<=1000000;
     
112. 
     
113. 第 1 行, 第 7 列[t1m]附近出现错误:
     
114. 语法分析出错.error code=-2007
     
115. SQL>create table t1m as select top 1000000 rownum c from big,big t1;
     
116. create table t1m as select top 1000000 rownum c from big,big t1;
     
117. 
     
118. time used: 1044.427(ms) clock tick:1750690052. Execute id is 308.
     
119. SQL>select count(*) ,sum(c) from t1m;
     
120. select count(*) ,sum(c) from t1m;
     
121. COUNT(*)                SUM(C)
     
122. 
     
123. 1       1000000 500000500000
     
124. 1 rows got
     
125. time used: 156.699(ms) clock tick:262639073. Execute id is 309.
     
126. SQL>
     

复制代码

gargoyle

希望国产数据库性能越来越强，应用越来越广。

xiehuanzhong

1，通过disql进行命令行创建用户后，用所创建的用户进行登录，用户名和密码都需要大写才能够登录进去。