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.
刷新表:在某些数据仓库中,整个表每年删除一次,然后装载一个替代的表,这个新表包含了除不再需要的数据以外的所有数据。
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.
在异步分离操作完成了分离后,可以看到分离的目标表已被归档、删除、或者附加到一些(其他)表上。
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.
例如,您可能需要浏览数据库,修改或删除表,执行扩展修改,在现有的表中添加列。
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 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.
有一天,他的主人邀请一位领主共同进餐,在上菜的时候,他不小心洒了几点食物屑在那位领主身上。
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的任何语句。
In the kitchen, Father dropped the book on the table, breaking the creased spine even more.
在厨房,父亲把书放在桌上,已经断裂的书脊弄得更散了。
Screen capture of empty pivot table with regions ready to receive dropped row fields, column fields, and data items
空pivot表的屏幕截图,其中有一些区域用来接收拖放的行字段、列字段和数据条目
While the add_column looks already familiar, you might be surprised to see the entire table needs to be dropped and then recreated, instead of using the remove_column.
虽然add_column看上去有点熟悉,但是您可能会惊奇地发现需要删除整个表,然后重新创建表,而不是使用remove_column。
You can set some table properties here, or if you prefer, you can set the properties after the table has been dropped on the design surface, by editing the values in the properties view.
您可以在这里设置一些表格属性,如果您愿意,您也可以在将表格拖到设计图面之后,通过编辑Properties视图中的数值来设置这些属性。
Note: Enterprise Replication does not allow dropping a column from a replicated table when one or more replicate definitions refer to the column being dropped.
注意:当一个或多个复制定义引用被删除的列时,EnterpriseReplication不允许从一个复制表中删除一列。
Last year's table-topper Russia dropped to 1.7 million pounds from 1.9 million in the first seven months of 2008.
去年的退税冠军俄罗斯人的退税额从去年的头7个月的190万镑下降到现在的170万镑。
You can either use a copy of your backup image and roll it forward to the time right before the table was dropped (point-in-time recovery), or you can restore a logical backup through the exp utility.
您可以使用备份映射的副本,并将它前滚至删除表之前的某个时间点(时间点恢复),或者您可以通过exp实用程序恢复逻辑备份。
I said in Part 1 that I was going to have a users table in SimpleDB, but it complicated the site too much, so I dropped it.
我在功能丰富的Perl: perl和amazon云,第1部分说过,我将在SimpleDB中使用一个用户表,但是它会使站点变得非常复杂,因此放弃了这个想法。
When a work table is dropped, two pages may remain allocated and they are returned to the work table cache.
工作表被删除后,这两页可能会保持分配状态并返回到工作表缓存中。
And for some reason, neither husband nor wife seemed to care any longer when a fork was dropped, milk was spilled or the table cloth was soiled.
因为某些原因,这对夫妻再也不在乎掉下的叉子、洒出的牛奶或是弄脏的桌布了。
应用推荐