用日志悄悄地进行处理:错误表。
检查错误表就能够方便地查明源表行以及出问题的坐标。
Inspection of the error table conveniently reveals the source row as well as the problematic coordinate.
Errortab指定错误表的名称,这个表包含无法复制的对象的错误信息。
Errortab specifies the name of a table containing error information for objects that could not be copied.
Errortabschema指定错误表的模式名,这个表包含无法复制的对象的错误信息。
Errortabschema specifies the schema name of a table containing error information for objects that could not be copied.
这个表空间用来容纳 ADMIN_COPY_SCHEMA过程所使用的元数据以及这个过程返回的错误表。
This table space is used to hold metadata used by the ADMIN_COPY_SCHEMA procedure as well as error tables returned by this procedure.
门捷列夫比迈耶更大胆,他甚至认为,如果测量到的原子质量在表中把一个元素对应于错误的位置,这个原子质量就是错误的。
Mendeleyev was bolder than Meyer and even assumed that if a measured atomic mass put an element in the wrong place in the table, the atomic mass was wrong.
我们经常感到我们无法控制我们的日程表,但这是一个错误的看法。
We often feel that we have no control over our schedule but this is a myth.
为了使设计的模式尽可能预防更多的错误,需要围绕着错误检查组织词汇表,有时候还要使用继承这样的高级特性。
Yet to design a schema that prevents as many errors as possible, you need to organize the vocabulary around the error checking, sometimes using advanced features such as inheritance.
但是,这次您不会收到指明不能放弃两个表的错误消息,因为您已经创建了它们(如 清单2 所示)。
This time, however, you don't get error messages saying the two tables can't be dropped, because you already created them (as shown in Listing 2).
这样编写样式表可以避免这种错误。
例如,如果错误删除了表,那么作为管理员,您有两种选择。
For example, if a table is mistakenly dropped, as an administrator you have two choices.
支持模式的样式表可以使用模式中包含的信息自动检测样式表中某些类型的错误。
Schema-aware stylesheets can use information contained in a schema to automatically detect some types of errors and mistakes in your stylesheets.
会议开始刚刚几分钟,经理就开始指出表中多处的错误。
After just a few minutes, he began pointing out numerous mistakes.
还可以指定一个错误页,以及一个样式表。
We can also assign an Error page, as well as a Cascading Style sheet.
表3还显示用户定义的错误消息也被返回。
Table 3 also shows that a user-defined error message is also returned.
您的目标是让MTK解析输入脚本,使源数据库基表的结构的错误尽可能地少。
Your goal is to get MTK to parse the input script with as few errors as possible about the basic table structures of the source database.
除了能够创建新表之外,您可能还想删除表—只有在偶然犯了输入错误或不再需要特定表时。
Apart from the ability to create new tables, you might also want to delete tables-only if you've made an accidental typing mistake, or when you no longer need a particular table.
表3只列出了最常遇到的错误。
Again, Table 3 lists the most common errors that can be encountered.
如果发生错误,对于每个错误,在表COPYSCHEMA . COPYERROR中写入一项。
If errors occurred, an entry for each error is written to table COPYSCHEMA.COPYERROR.
这两种情况下,若在相同会话中企图重新声明临时表将导致如下错误。
In both cases, attempts to re-declare a temporary table within the same session will result in the following error.
图6中的错误日志表的定义如下
标签D的语句导致一个错误,因为t1表的CREATETABLE 语句被执行了回滚。
The statement at D results in an error because the CREATE TABLE statement for the t1 table has been rolled back.
这个样式表要复杂一些,因为还要处理错误。
This one is more complex because it also does error processing.
现在,如清单20所示,当用户重新连接到数据库,并试图访问表时,将接收到错误消息。
Now, as shown in Listing 20, when users reconnect to the database and try to access the table, they receive an error.
引用完整性是一个美妙的sql术语,它指的是保持数据库中的所有数据都是干净的,没有错误或者多余的数据,表之间的连接准确合理。
Referential integrity is a fancy SQL term that refers to keeping all the data in your database clean, free from incorrect or unused data, and accurate in terms of joins across tables.
除了涉及基表结构的错误或警告之外,其他错误或警告可以忽略。
Errors or warnings relating to anything but the basic table structure can be ignored.
另一个更大的错误隐藏在这个计划的日程表中。
清单8中显示的xsl样式表包含具体的错误消息,可以解释验证动作为何失败,并将它返回给发出请求的客户机。
The XSL stylesheet shown in Listing 8 obtains the specific error message that explains why the validation action failed and returns it to the client that issued the request.
简单地运行两次会产生错误,因为相同的星星名称(作为表的主键)使用了两次,则会由于重复的主键值导致错误。
Simply running it twice will produce an error, because the same star names (which are the primary key for the table) are used again, causing an error with duplicate primary key values.
如果忘记编写当前节点的相对表达式,那么最后就会得到如清单7所示的错误样式表。
If you forgot to write expressions relative to the current node, you can easily end up with the wrong stylesheet, as in Listing 7.
应用推荐