You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for alter database


1 to 20 of 2043724 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


SQL Language Reference, Release 19c

ALTER DATABASE

ALTER DATABASEPurpose Use the ALTER DATABASE statement to modify, maintain, or recover an existing database. See … Oracle Data Guard Concepts and Administration for additional information on using the ALTER DATABASE … Prerequisites You must have the ALTER DATABASE system privilege.

SQL Language Reference, Release 19c

ALTER DATABASE LINK

ALTER DATABASE LINKPurpose Use the ALTER DATABASE LINK statement to modify a fixed-user database link when the … database link with the ALTER DATABASE LINK statement. This statement is valid only for fixed-user database … information on these two types of database links.

SQL Language Reference, Release 19c

ALTER DATABASE DICTIONARY

ALTER DATABASE DICTIONARYPurpose To encrypt obfuscated database link passwords and use the TDE framework to manage the … TDE Master Key. For more see the Database Security Guide. The instance initialization parameter … sensitive information in data dictionaries, for example database link passwords stored in SYS.LINKS$. It … locator signature key for LOB

SQL Language Reference, Release 19c

ALTER PLUGGABLE DATABASE

Table 11-2 PDB Open ModesPurpose Use the ALTER PLUGGABLE DATABASE statement to modify a pluggable database (PDB). The PDB … snapshots using the snapshot_clauses Note: You can perform all ALTER PLUGGABLE DATABASE tasks by … connecting to a PDB and running the corresponding ALTER DATABASE statement.

SQL Language Reference, Release 18c

ALTER DATABASE

ALTER DATABASEPurpose Use the ALTER DATABASE statement to modify, maintain, or recover an existing database. See … Oracle Data Guard Concepts and Administration for additional information on using the ALTER DATABASE … Prerequisites You must have the ALTER DATABASE system privilege.

SQL Language Reference, Release 18c

ALTER DATABASE LINK

ALTER DATABASE LINKPurpose Use the ALTER DATABASE LINK statement to modify a fixed-user database link when the … database link with the ALTER DATABASE LINK statement. This statement is valid only for fixed-user database … information on these two types of database links.

SQL Language Reference, Release 18c

ALTER DATABASE DICTIONARY

ALTER DATABASE DICTIONARYPurpose To encrypt obfuscated database link passwords and use the TDE framework to manage the … more on this refer to the Database Security Guide. The instance initialization parameter COMPATIBLE … information in data dictionaries, for example database link passwords stored in SYS.LINKS$. It

SQL Language Reference, Release 18c

ALTER PLUGGABLE DATABASE

Table 11-2 PDB Open ModesPurpose Use the ALTER PLUGGABLE DATABASE statement to modify a pluggable database (PDB). The PDB … snapshots using the snapshot_clauses Note: You can perform all ALTER PLUGGABLE DATABASE tasks by … connecting to a PDB and running the corresponding ALTER DATABASE statement.

SQL Language Reference, Release 19c

ALTER SESSION

Initialization Parameters and ALTER SESSIONdatabase. Prerequisites To enable and disable the SQL trace facility, you must have ALTER SESSION … documentation for more information. ENABLE | DISABLE GUARD The security_clause of ALTER DATABASE … with the primary database. An ALTER SESSION statement with this clause blocks until redo

SQL Language Reference, Release 19c

ALTER TABLESPACE

ALTER TABLESPACEtemp file in smallfile tablespaces, use the ALTER DATABASE... autoextend_clause (see … ALTER DATABASE \" BACKUP Clauses \" for information on moving all data files in the database into and … out of online backup mode ALTER DATABASE alter_datafile_clause for information

Automatic Storage Management Administrator's Guide, Release 19c

Administering Oracle ASM Files, Directories, and Templates

Moving Data Files Between Disk Groups With ALTER DATABASEYou can use the ALTER DATABASE MOVE DATAFILE SQL statement to move data files between disk groups … with ALTER DATABASE MOVE DATAFILE /* Create a new disk group DATA2 using ASMCA, ASMCMD, or SQL … file in DATA to EXAMPLE_STORAGE in DATA2 ALTER DATABASE MOVE DATAFILE '+DATA/ORCL/DATAFILE/EXAMPLE

Multitenant Administrator's Guide, Release 19c

Administering a CDB

13.4.2 Modifying an Entire CDB Using ALTER DATABASEYou can use the ALTER DATABASE statement to modify an entire CDB, including the root and all PDBs … . Most ALTER DATABASE statements modify the entire CDB. For a list of statements that modify the … following prerequisites must be met: The current user must be a common user with the ALTER DATABASE

Multitenant Administrator's Guide, Release 19c

Administering PDBs

15.4.2 Modifying a PDB with the ALTER PLUGGABLE DATABASE StatementTo modify the attributes of a single PDB, use the ALTER PLUGGABLE DATABASE statement. When the … current container is a PDB, an ALTER PLUGGABLE DATABASE statement modifies the PDB. The modifications … . For all other operations performed using the ALTER PLUGGABLE DATABASE statement,

Multitenant Administrator's Guide, Release 19c

Administering a CDB

13.4.4 Modifying the CDB Root Using ALTER DATABASETo modify only the root of a CDB, use the ALTER DATABASE statement. When the current container is … the root, some ALTER DATABASE statements modify the root without directly modifying any of the PDBs … ALTER PLUGGABLE DATABASE statement. Prerequisites To modify the root, the current

SQL Language Reference, Release 19c

ALTER LOCKDOWN PROFILE

Table 11-1 PDB Lockdown Profile Featuresfollowing statements in any combination of uppercase and lowercase letters: ALTER DATABASE ALTER … PLUGGABLE DATABASE ALTER SESSION ALTER SYSTEM Use ALL to specify all statements in the preceding list. Use … : ALTER DATABASE, ALTER PLUGGABLE

Database Administrator's Guide, Release 19c

Using Oracle Managed Files

17.3.7.1 Using the ALTER DATABASE ADD LOGFILE StatementThe ALTER DATABASE ADD LOGFILE statement lets you later add a new group to your current redo log … ' DB_CREATE_ONLINE_LOG_DEST_2 = '/u02/oradata' The following statement is issued at the SQL prompt: SQL> ALTER DATABASE ADD … at Database Creation \". If a file name is not provided and you have not provided

Database Administrator's Guide, Release 19c

Using Oracle Managed Files

17.3.7.2 Using the ALTER DATABASE OPEN RESETLOGS Statementissue the ALTER DATABASE OPEN RESETLOGS statement. The rules for determining the directories in which to … or specified nonexistent file names, then the database creates redo log files for you when you … in \" Specifying Redo Log Files at Database Creation \". Parent topic: Creating Redo Log Files Using Oracle Managed

SQL Language Reference, Release 18c

ALTER TABLESPACE

ALTER TABLESPACEtemp file in smallfile tablespaces, use the ALTER DATABASE... autoextend_clause (see … ALTER DATABASE \" BACKUP Clauses \" for information on moving all data files in the database into and … out of online backup mode ALTER DATABASE alter_datafile_clause for information

SQL Language Reference, Release 18c

ALTER SESSION

Initialization Parameters and ALTER SESSIONdatabase. Prerequisites To enable and disable the SQL trace facility, you must have ALTER SESSION … documentation for more information. ENABLE | DISABLE GUARD The security_clause of ALTER DATABASE … with the primary database. An ALTER SESSION statement with this clause blocks until redo

Database Administrator's Guide, Release 9

Managing Database Settings

Using alter database in MaxLDatabase Properties Oracle Essbase Administration Services Online Help MaxL alter database Oracle … . Using alter database in MaxL Issue a separate alter database statement for each database setting … To specify most database settings,