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...
Enabling Automatic Shared Memory Management This section describes how to change to automatic shared memory management if either automatic memory management or manual shared memory management is ...
Enabling Flashback Database To revert the entire database to a prior point in time, you can either revert the entire database to a prior point in time by restoring a backup and doing point-in-time recovery, or you can enable Flashback Database. When you enable Flashback Database, the database ge...
Enabling Row Movement on a Table Before you can use Flashback Table, you must ensure that row movement is enabled on the table to be flashed back, or returned to a previous state. Row movement indicates that rowids will change after the flashback occurs. This restriction exists because if rowids...
Encrypted Tablespaces Encrypted tablespaces primarily protect your data from unauthorized access by means other than through the database. For example, when encrypted tablespaces are written to backup media for travel from one Oracle database to another or for travel to an off-site facility for ...
From an existing database (structure as well as data) You can create a new template that has both the structural information and physical data files of an existing database. Databases created using such a template are identical to the source database. User-defined schemas and their data will be ...
Full Backups and Incremental Backups A full backup of a data file includes all used blocks of the data file. A full backup can be either an image copy or backup set. An incremental backup copies only those blocks in a data file that change between backups. A level 0 incremental backup, which cop...
