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...
Displaying Views You can use SQL Developer to list the views in a specified schema. You can also display the view definitions. To display views: 1. In the Connections navigator, navigate to the Views node for the schema that includes the view you want to display. If the view is in your own sch...
Dropping a Table For the purpose of learning about Flashback Drop, you will create a new table named reg_hist and then drop it. The database places the table in the recycle bin so that it can be retrieved with the Flashback Drop feature. To create and then drop a table: 1. Connect SQL*Plus to t...
Enabling Archiving of Redo Log Files To back up the database while it is open, or to be able to perform complete or point-in-time media recovery, you must enable the archiving of redo log files. To do so, you place the database in ARCHIVELOG mode. You can determine if archiving of redo logs is e...
Enabling Automatic Memory Management If you did not enable automatic memory management when you installed and configured your database, then Oracle recommends that you do so after installation, unless you are an experienced DBA with specific reas...
