List the dropped table history by issuing the command.
通过发出命令来列出被删除表的历史。
Roll forward using complete recover dropped table to e:\tmp.
使用完全恢复将被删除表前滚至e:\tmp。
Now, create the dropped table from the list dropped table DDL statement.
现在,在被删除表的ddl语句清单中创建被删除的表。
You will need the backup ID and the DDL for the dropped table in the subsequent steps.
在一些后续步骤中,您需要用到被删除表备份id和DDL。
Issue the commands below to check whether a table space is enabled for dropped table recovery and if not, turn it on.
发出下面的命令来检查是否为表空间启用了对被删除表的恢复支持,如果没有启用,就打开它。
You will notice few things; the backup ID (eg 000000000000bb000002000d), dropped table start and end time (eg. 20040705150008) and the DDL for the dropped table.
您将注意到少数的几件事;备份ID(比如 000000000000bb000002000d),表删除操作的开始和结束时间(比如 20040705150008)及被删除表的DDL。
If there's a statement failure, the table will be marked as inaccessible and must be dropped.
如果有一条语句失败,那么这个表将被标记为不可访问的,并且需要被删除掉。
Refresh table: In some data warehouses, the entire table is dropped once per year and a replacement table is loaded with all the data except for the data that is no longer needed.
刷新表:在某些数据仓库中,整个表每年删除一次,然后装载一个替代的表,这个新表包含了除不再需要的数据以外的所有数据。
For example, if a table is mistakenly dropped, as an administrator you have two choices.
例如,如果错误删除了表,那么作为管理员,您有两种选择。
Purge: in some recent history tables, every few days the entire table is dropped and recreated because data is now available in another table with a longer history.
清洗:在某些最近历史表中,每过一些天就删除整个表,并重新创建表,数据将放在有更长历史的另一个表中。
After the asynchronous detach operation has completed the detach, the target table of detach is available to be archived or dropped or attached to some (other) table.
在异步分离操作完成了分离后,可以看到分离的目标表已被归档、删除、或者附加到一些(其他)表上。
The typed table that is being dropped cannot have any subtables.
正被删除的类型化表不能拥有任何子类型。
He dropped his head on his palm that was resting on the table, and started banging his head against his white mottled hand.
他把头埋进靠着桌子的手掌中。然后开始用头撞击他那斑驳的白色的手。
In this scenario, you modified the table schema and completely dropped the side tables and some of the shredded columns.
在这个场景中,修改了表模式,完全删除了副表和一些分解的列。
This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
这说明,在创建或删除函数索引时,执行索引的表中始终持有一个排他锁。
For example, you can browse your database for tables that need to be modified or dropped, perform extended alters, and add columns to an existing table.
例如,您可能需要浏览数据库,修改或删除表,执行扩展修改,在现有的表中添加列。
远程表被删除。
The source table is either dropped or kept based on one of the ADMIN_MOVE_TABLE input parameters.
根据ADMIN_MOVE_TABLE输入参数之一,源表将被删除或保留。
Invalid table - The remote table, view, or data set has been dropped.
无效表——远程表、视图或数据集被删除。
After copying all rows in table SALES successfully to table SALES_TMP, the source table SALES can be dropped (drop table statement).
在把sales表中的所有行成功地复制到SALES _ tmp表之后,可以删除源表(DROPtable语句)。
The NOT NULL attribute of column Credit_Line in table ACCOUNT has to be dropped because some other account types have been added that do not have a credit line.
ACCOUNT表中的 Credit_Line列的NOTNULL属性必须删除,这是因为添加了没有信用行的其他账号类型。
If the destination address is not in the routing table, the packet is dropped.
如果其目的地址不在这个路由表里,路由器就将数据包丢弃。
If a table is dropped, its segments become immediately available for reuse at the COMMIT point, without requiring the REORG utility to be executed.
如果一个表被删除,在执行COMMIT之际,它的段就立即可以为其他表所用,而不需要执行REORG实用程序。
One day, while serving the meal, he dropped a few crumbs of food on the Lord who was invited to the table with his master.
有一天,他的主人邀请一位领主共同进餐,在上菜的时候,他不小心洒了几点食物屑在那位领主身上。
He dropped the basket and his threadbare overcoat on the wooden table.
他把篮子和他那件破旧的大衣放到木桌上。
However, be warned that if there is a statement failure, the table will be marked as inaccessible and must be dropped.
然而要注意,如果有语句遭到失败,那么表将被标记为不可访问,而且必须被删除。
Containers can be added to, or dropped from, a DMS table space, and their sizes can be modified.
可以将容器添加到dms表空间,或者从dms表空间中删除容器,而且可以更改容器的大小。
About 10 minutes later, two women walked over to my table — in front of everyone — and dropped a folded napkin in my lap.
大约10分钟以后,两个妇女走到我的桌边——在大家面前——将一张折叠的餐巾纸放在我膝盖上。
If the collected lock event data should not be kept for further analysis purposes, the unformatted event table must be dropped manually using the drop table statement, as shown in Listing 22.
如果不需要保留所收集的锁事件数据用作将来的分析,必须使用DROPtable语句手动删除非格式化事件表,如清单22所示。
If the connection is lost or the table is dropped, any statement referring to the DGTT needs to be recompiled every time the table is re-declared.
如果连接失败,或者该表已删除,那么每次重新声明这个表时,都需要重新编译引用DGTT的任何语句。
应用推荐