While the drop table space operations are running, execute the following script from another session.
在执行删除表空间的操作时,从另一会话执行下列脚本。
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表之后,可以删除源表(DROP table语句)。
Enter the SQL from the transactiondemo-ejb.sql file (without the drop table statement) into the SQL Command text area, and click the Run SQL button, as shown in Figure 3.
将SQL从 transactiondemo-ejb.sql文件(不包含drop table语句)输入到 SQLCommand文本区,点击Run SQL按钮,如图 3 所示。
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.
如果不需要保留所收集的锁事件数据用作将来的分析,必须使用DROP table语句手动删除非格式化事件表,如清单22所示。
Finally, the DROP table statement deletes the empty table from the schema.
最后,DROP table语句删除模式中的空表。
Note that the debugger might generate warnings related to DROP TABLE statements, which you can ignore.
注意,调试器可能会产生与DROP table语句有关的警告,可以不理会它。
Note that the debugger might generate warnings related to DROP TABLE statements, which can be ignored.
注意,调试器可能生成与DROP table语句相关的警告,对此可以忽略。
The syntax is simple: you append the fully qualified name and a semicolon to the DROP TABLE SQL command, and you're finished.
语法很简单:把完全限定名称和分号放在DROP TABLESQL命令后面,就完成了。
The syntax is simple: you append the fully qualified name and a semicolon to the DROP TABLE SQL command, and you're finished.
语法很简单:把完全限定名称和分号放在DROP TABLESQL命令后面,就完成了。
应用推荐