请求帮忙指导：创建数据库有错......
<P>我是初学者，实际中遇到了些困难，请大家帮帮忙。我的服务器环境是unix ware 7+sybase 11.92<BR>使用sybase 客户端的sql advantage 执行sql语句，出现如下错误:</P><P>Server Message:Number156, Severity15<BR>Line 7:<BR>Incorrect syntax near the keyword 'use'. <BR>(1 row affected)<BR>Server Message:Number5146, Severity16<BR>Line 6:<BR>The VDEVNO of 10 is out of range.The maximum VDEVNO allowed is 9. <BR>Server Message:Number1804, Severity10<BR>Line 1:<BR>There is no disk named 'tempdb1'. Checking other disk names. <BR>Server Message:Number5009, Severity16<BR>Line 1:<BR>ALTER DATABASE failed. Some disk names listed in command were not found. Check that names exist and are spelled correctly before re-running command</P>
<P>请问这些server message<BR>返回的这些错误号及级别号代表什么意思？语句问题出在哪里。有没有一些参考资料专门介绍<BR>这些返回数字是代表什么意思的？还有一个问题，创建一个数据库一定得先创建数据库裸设备吗？<BR>谢谢！执行的语句如下：</P>
<P>disk init<BR> name = "tempdb1",use master<BR>go</P>
<P>declare @vdevno int <BR>select @vdevno = max(convert(tinyint, substring(convert(binary(4),d.low), v.low,1))) + 1 <BR>from master.dbo.sysdevices d, master.dbo.spt_values v <BR>where v.type = 'E' and v.number = 3</P>
<P>disk init<BR> name = "tempdb1",<BR> physname = "/home/sybase/data/tempdb1",<BR> vdevno = @vdevno,<BR> size = 51200<BR>go<BR>alter database tempdb on tempdb1=100<BR>go </P> 去书店弄点书恶补一下吧。这方面的资料我也没用，也用不到。呵呵 SYBASE有专门的文档，FTP上有完整的ASE12.5.2的文档。 可以用WINDOWS下的客户端操作<br>
页:
[1]