can recover the two view

Related Posts of can recover the two view

• UNDO carried out on the table through Oracle data recovery tests

  rn In the past to achieve - 9i Syntax: select * from <table_name> as of scn / timestamp xxx; For example: SQL> spool e: \ flashback.sp SQL> drop table t1 purge; The table has been deleted. SQL> create table t1 2 (n number); The table h ...

• Oracle database in the Recycle Bin

  A few days ago the database gave a number of useless delete a few tables, and later see what the current user, there are some table, actually featured a lot of garbled, and later checked the Internet know, these are I deleted The tables were put to t ...

• oracle10g new features: flash recovery area (Flash recovery area)

  oracle10g new features: flash recovery area (Flash recovery area) Flashback to provide information, so that they can be found in the past, when necessary, the consistency of data at some point, this is achieved through the Undo. That there are substa ...

• Study Notes flashback

  Study Notes flashback 1. Characteristic as to provide a 10G new features, you can view the past through flashback data and can recover data to a previous state, if no such properties, would like to view past data, it may be necessary to restore a med ...

• Select

  4. WITH query_name AS (subquery)

• oracle technology

  Oracle database today to study the Cluster, DataGuard, the logic of the physical backup, flash back, as well as technical Rman. On learning experiences: rn Cluster: 10g or later to use cluster operating crs; the use of VIP, ASM, OCR technology; rn Ba ...

• How do I change the control file automatically back up the path

  In Oracle10g, if the use of a flash back to our area, then the control will automatically back up files stored in the flashback area. Sometimes, for security, we need to control the transfer of files automatically backed up to another directory, whic ...

• Cloning Oracle Home (10g2)

  Cloning an existing Oracle Home, Exempt newly installed software oracle10g the suffering of the original Oracle Home if a patch has been installed on the clinics to save the patch hit. First, in the aim to do the installation on the host 172.19.111.3 ...

• High Availability Oracle Flashback

  Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...