闪回后,把删除的表,及索引都会恢复。
现在,在被删除表的ddl语句清单中创建被删除的表。
Now, create the dropped table from the list dropped table DDL statement.
如果从一个带有10个索引的表删除一行,DB 2必须删除与被删除的行关联的所有索引条目。
Delete a row from a table with 10 indexes, and DB2 must remove all index entries associated with the deleted rows.
重命名旧的删除表。
在创建或更新文档类型时,可以从文档类型选择需要添加或删除的属性表。
While creating or updating a document type, you can select property sheets to be added or removed from the document type.
清单7演示了从指定的工作表删除最后一行的过程。
Listing 7 illustrates, by deleting the last row of a specified worksheet.
存档之后,从审计日志表中删除老的条目。
Once archived, those old entries are removed from the audit log tables.
删除目标表不需要的所有结果集列。
Delete all result set columns except those required by the target table.
最后,DROPtable语句删除模式中的空表。
Finally, the DROP table statement deletes the empty table from the schema.
TableName:按照名称指定将从中删除分区的分区表。
TableName: Identifies the partitioned table, by name, that a partition is to be removed from.
最后使用查找程序是删除这个对象的注册表。
The final aspect of using the find method deals with deleting registration of the object. TestObject.find
在某些情况中,您还需要删除表以及表中的所有数据,修改数据库的设计,然后重新加载数据。
In some cases, you may have to unload the tables, delete all the data, change the database design, then reload the data.
发出下面的命令来检查是否为表空间启用了对被删除表的恢复支持,如果没有启用,就打开它。
Issue the commands below to check whether a table space is enabled for dropped table recovery and if not, turn it on.
您可以应用规范化的概念删除表的冗余部分,然后将它们放在次表中。
You could apply the concept of normalization to remove redundant portions of the tables and place them in secondary tables.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
“数据删除”指定从此表中删除数据的时间间隔。
Data delete specifies the interval at which data from this table is deleted.
可以在原来发布服务的注册表中删除服务,也可以在服务被同步到的注册表中删除它们,这两种情况有很大差异。
There is a big difference between deleting services in the registries where they were originally published, versus deleting services in registries where they were synchronized to.
该用户需要在SAMPLE数据库中创建、修改和删除数据表的权利。
The user needs to have rights to create, modify, and delete tables in the SAMPLE database.
如果没有包括任何where子句,则删除表中的所有行。
If no WHERE clause is included, all rows in the table are deleted.
而且要能够对过去仓库处理活动的任何历史加以恢复;备份文件应该包含从档案表中删除的数据。
And also that any past history of the warehouse processing activity can be recovered; backup files should contain the data that has been deleted from the archive table.
这些操作都要求用户检索将要修改或删除的工作表条目,根据需要对条目作出修改,然后将其传递回服务器以完成执行。
Both these operations require the user to retrieve the worksheet entry to be modified or deleted, make changes to the entry as required, and then transmit it back to the server for execution.
每当数据库的模式发生更改,或者进行像添加或删除数据文件、添加或删除表空间这样的更改时,建议管理员执行脱机备份。
Administrators are advised to do an offline backup whenever the schema of the database changes, or changes are made such as adding or removing data files, and adding or removing of table Spaces.
日期和时间应该早于运行错误的应用程序(即删除表中的行)的时间。
The date and time should be prior to when the bad application ran (when you deleted the table rows).
但是,一般地,您不希望删除表中的所有行;而是有选择地删除行。
In general, however, you don't want to delete all rows from a table; instead, you'll selectively delete rows.
在DB2中运行在线备份的惟一约束是:当一个表空间正在被备份的时候,不能删除这个表空间。
The only restriction when running an online backup in DB2 is that you cannot drop a table space while that table space is actively being backed up.
正被删除的类型化表不能拥有任何子类型。
The typed table that is being dropped cannot have any subtables.
基于被修改复制表的新模式创建一个新的删除表。
Creates a new delete table based on the new schema of the altered replicated table.
清单4演示了删除清单3中的工作表。
Listing 4 has an example of deleting the worksheet from Listing 3.
从您装载的表中删除被修剪过的行,确保以后不会将重复的行装载到表中,这是一种很好的做法。
It is a good practice to delete any pruned rows from the table that you loaded in order to ensure that you do not load duplicate rows into the table at a later time.
还可以添加和删除DB 2表中的条目。
应用推荐