Database Identification In the Global Database Name field, enter the database name in the form database_ name.domain_name. In the SID field, enter the system identifier. The SID defaults to the database name and uniquely identifies the instance that runs the database. If you enable the Create a...
Database Identifiers These options include your global database name and system identifier (SID). The SID is a unique identifier that is used to distinguish this instance from other Oracle Database instances that you may create later and run concurrently on your system. The global database name ...
Database Options This window includes the Sample Schemas tab and the Database Vault & Label Security tab. On the Sample Schemas tab, you can specify for the sample schemas to be created in your database, and for custom SQL scripts to be run after database creation: ■ Sample Schemas—Select S...
Database Releases Supported by DBUA If the release number of your current Oracle Database appears in the following list, you can use DBUA to perform a direct upgrade of your database to Orac...
Database Template This window enables you to select the type of database template to use to create the database. You can select: ■ General Purpose or Transaction Processing ■ Custom Database ■ Data Warehouse EM Express supports Oracle sing...
Default Territory—In this list, select the name of the territory whose conventions are to be followed for day and week numbering or accept the default. The default territory also establishes the default date format, the default decimal character and group separator, and the default International ...
Deleting a Role Use caution when deleting a role, because EM Express deletes a role even if that role is currently granted to one or more users. Dropping (deleting) a role automatically removes the privileges associated with that role from all users that had been granted the role. To
Deleting a Table Column In this example, you delete the po_requestor_name column that you added to the purchase_orders table in "Example: Adding Table Columns" on page 8-13. To delete ...
Deleting Obsolete Backups This section explains how to delete obsolete backups, which are those no longer needed by the configured retention policy. If you use a fast recovery area as your only disk-based backup destination, then you never have to delete obsolete backups from disk. The fast reco...
Displaying Backup Reports Backup reports contain summary and detailed information about past backup jobs run by RMAN. The view V$RMAN_BACKUP_JOB_DETAILS contains information about backup jobs run by RMAN. This view contains information such as the time taken for the backup, when a job started an...
