数据库升级后打开表或存储过程出错(可解决)
原来的数据库在ASE12.5.01+10430的EBF是正常的，后来升级到更高的12.5.03的14499再打开库的表或存储过程都出类似的错误：cannot run query--referenced object (name NAME NOT RECOVERABLE)dropped during query optimization.
应该如何解决。只有用户库这样，其它的库正常。除了BCP重新导出导入，会不会还有别的方法解决。这种问题是如何发生的？
<P>CSDN hobbylu(东方一剑) 提供解决方案：
<a href="http://community.csdn.net/Expert/topic/3494/3494602.xml?temp=.9650537" target="_blank" >http://community.csdn.net/Expert/topic/3494/3494602.xml?temp=.9650537</A></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">use dbname</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics syslogins</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics sysusers</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics sysattributes</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics sysalternates</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics sysobjects</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics systypes</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics sysprotects</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics syscolumns</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics syssegments</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">delete statistics systhresholds</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics syslogins</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics sysusers</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics sysattributes</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics sysalternates</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics sysobjects</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics systypes</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics sysprotects</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics syscolumns</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics syssegments</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">update statistics systhresholds</FONT></P><P 0cm 0cm 0pt"><FONT face="Times New Roman">go</FONT></P>
页:
[1]