Politechnika Śląska - strona 112

Displaying Views - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 525

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 525

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 357

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 350

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 Flashback Database - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 399

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 476

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 441

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 data - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 329

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 420

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...