SQL> alter database open resetlogs;
打开数据库。
SQL> alter database open read only;
在只读模式下打开备用数据库。
Open the database - alter database open
打开数据库 ——alter databaseopen。
The ALTER DATABASE command is used to add storage paths.
使用ALTER DATABASE命令来添加存储路径。
Open the database and reset the logs - alter database open resetlogs.
打开数据库并重新设置日志——alter database open resetlogs。
Offline the lost datafile: Alter database datafile '/path/filename.dbf' offline
使丢失的数据文件处于脱机状态:Alter databasedatafile'/path/filename.dbf'offline。
Convert an existing database to an automatic storage database: DB2 ALTER database.
将一个数据库转换为自动存储数据库:DB 2ALTER database。
Add storage paths to a database already enabled for automatic storage: DB2 ALTER database.
将存储路径添加到一个已启用自动存储的数据库中:DB 2ALTER database。
Add a new member to the group - Alter database add logfile member '/fullpath/log_filename.
将新的成员添加到这个组 ——Alter databaseaddlogfilemember'/fullpath/log_filename.log' reuse to group n;
Incomplete recovery will require a reset of the logs by issuing Alter Database Open Resetlogs command.
不完全恢复将要求通过发出Alter DatabaseOpen Resetlogs命令来重新设置日志。
All the redo logs after the alter database open resetlogs will render useless and will not be good for recovery.
alter databaseopen resetlogs之后,所有重做日志都将表现为无用,所以它不适合于恢复。
Open the database and reset the logs - alter database open resetlogs (Note after opening using resetlogs will create online log files).
打开数据库并重新设置日志——alter databaseopenresetlogs(注意,使用resetlogs打开后将创建联机日志文件)。
Thus, to modify an existing database named TEST_DB so that it USES automatic storage, you would execute an ALTER database command that looks like this.
这样,要修改一个名为test_db的现有数据库,使其使用自动存储,则可以执行如下所示的ALTER DATABASE命令。
This used to be a two step process where you were required to issue an ALTER DATABASE partition GROUP statement to add or drop the partitions first.
这在过去是由两个步骤组成的一个过程,首先需要发出ALTER DATABASEPARTITIONgroup语句来添加或删除分区。
Since the redo log group is inactive and is archived, just clear the redo log - alter database clear logfile group N (where N is the group # of the lost redo log)
由于重做日志组是不活动和归档的,所以只需清除重做日志即可 ——alter databaseclear logfilegroupN(其中 N 是丢失的重做日志的组 #)。
You are advised to issue the ALTER DATABASE partition GROUP statement to customize the tablespace setting and to control the container layout in the new partition.
建议发出ALTER DATABASEPARTITIONgroup语句来定制表空间设置,并控制新分区中的容器布局。
There is new functionality to create and alter roles and assign privileges to database objects.
具有创建和更改角色、为数据库对象分配权限的新功能。
Because this restriction is removed, even if the database is not created in UTF-8, a user can alter a table to add an XML column or create a new table with XML columns.
由于去掉了这个限制,即使数据库不是用utf - 8格式创建的,用户也可以更改一个表以添加xml列,或者创建一个包含xml列的新表。
In combination with enhancements to the ALTER TABLE statement, a convenient way for managing different versions of a database solution was created.
再结合使用对ALTERtable语句的改进,就可以方便地管理数据库解决方案的不同版本。
This enables DBAs to do everything to the database that they would ordinarily do-perform regular administration tasks, load data, use utilities-but not see or alter the data.
这让 DBA 能够对数据库执行他们原来所做的所有操作(执行日常管理任务、装载数据、使用实用程序等等),但是不会看到或修改数据。
As you want to execute the following statements against the target database MYSAMPLE, you alter the CONNECT statement accordingly.
因为希望对目标数据库mysample执行下面的语句,所以要相应地修改CONNECT语句。
The recent appearance of a new database, the fruit of a project called EU-KLEMS, that accounts for the sources of European growth and productivity does not alter this broad impression.
一项叫做EU-KLEMS的工程推出了一种新的数据库系统,该系统阐述了欧洲经济的增长和生产率提高的源泉,只是它的出现没有改变欧洲这些主要的回忆。
A hacker enters a malformed SQL statement into the textbox that changes the nature of the query so that it can be used to break into, alter, or damage the back-end database.
黑客向文本框中输入不正确的sql语句以更改查询的性质,从而可以使用它入侵、更改或损坏后端数据库。
You can also drop and drop other database changes or prompt changes by clicking CREATE, ALTER, or drop.
还可以通过单击CREATE、ALTER或DROP设置其他数据库修改。
Use Optim Database Administrator (included with AESE) to adjust DB2 parameters, alter objects, and analyze the impact of potential changes.
利用OptimDatabaseAdministrator(包含在AESE 中)来调整DB2参数、改变对象、以及分析潜在变化的影响。
The new tooling introduces a new set of IBM designers to create, alter, and clone database objects.
这款新工具引进了一系列新的IBM设计器用于创建、更改和复制数据库对象。
You can resize its columns, and if you enter more backorder items in the database with a status of "Order Stock," you can also alter sorting of data in the grid by clicking a column.
您可以调整它 纵列的大小,如果您在数据库输入更多 “OrderStock”状态的后台命令,您还可以通过点击一个纵列来更改这个表格中数据的分类。
You can easily attach and detach the partitions using the DB2 alter table command to move the data from one table (production table) to another table (history table) in the same database.
您可以很容易使用DB 2altertable命令来附加和分离分区,从而将数据从一个表(生产表)移动到同一个数据库的另一个表(历史表)中。
Follow the guide above to alter the information in the database.
遵循上述的指南来更改数据库中的信息。
Once again, this feature involves only Hibernate and the database, and thus doesn't alter the class hierarchy.
再次声明,这些特性只包含Hibernate和数据库,所以不会改变类的层次结构。
应用推荐