Oracle

Case 2--a table (DML) that restores a point in time past 1, based on Change (SCN) Sql> Conn Scott/tiger Connected. Sql> select * from TB01; Id ---------- 1 2 3 sql> drop table Tb01 purge; Table dropped. Sql> CREATE TABLE TB01 (ID int)

1. What is Audit The audit (Audit) is used to monitor the database operations performed by the user, and ORACLE will deposit the audit trail results to the OS file (the default location is $oracle_base/admin/ $ORACLE _sid/adump/) or database

Oracle Date Time Function encyclopedia To_date format (in time: 2007-11-02 13:45:25 for example) Year: YY two digits two-digit year display value: 07 YYY three digits three-digit year display value: 007 YYYY four digits four-digit year display

1. View all table space sizes Select Tablespace_name,sum (bytes)/1024/1024 from Dba_data_files Group BY Tablespace_name; 2. Unused table space size Select Tablespace_name,sum (bytes)/1024/1024 from Dba_free_space Group BY Tablespace_name; 3.

Bulk gets the number of rows per child of the specified partition table! Otherwise manual inquiry too troublesome! ---View the number of rows per child of a specified partition table Create or replace procedure show_tabparcnt (Partiton_tablename

Data Guard offers two main services: 1 Redo Transport Service: The Primay end of the redo log transmission to one or more standby destinations. 2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the

System Checkpoint SCN (V$database (checkpoint_change#)) Data file Checkpoint (V$datafile (checkpoint_change#)) Data file termination SCN (V$datafile (last_change#)) Checkpoints stored in data files Start SCN (V$datafile_header (checkpoint_change#

EXPDP's Network_link As we know, EXPDP the default is to export the local database, the Network_link is to export the remote database to the local server, and its steps are as follows: Terminology Description: SOURCE database: Remote

1, first set oracle_sid=manual 2. Create a password file Enter/u01/app/oracle/product/10.2.0/db_1/dbs directory, execute command to create database password file [Oracle@myorcl dbs]$ orapwd file=orapmanual password=oracle 3, create the desired

Scenario: storage media is corrupted, resulting in loss of control files, the need to replace the hard drive, and to re-establish control files.(1) Modify initialization parameter control_files, change control file locationsql> ALTER SYSTEM SET

1, store all things log. Redo the two concepts of the log, redo the log group and redo log group members. There should be at least two log group files in a database, one group written and then another, which is written in turn. There is at least

Data files (Details of the data file are documented in the control file) • Each Oracle database must have at least one data file for storing database data • Multiple data files should be placed on different disk to improve access speed 1. Main

Definition of a view View, also called a virtual table, does not occupy physical space, which is also a relative concept, because the definition statement of the view itself is still stored in the data dictionary. The view has only a logical

1 The easiest way is to log in with the Pl/sql tool, select the SQL statement, and then press F5; 2 with Pl/sql tool login, open command Window A) execution: Explain plan for SELECT * dual;--red part can be replaced with your SQL statement b)

Application scenario: Easy and quick recovery of table data; Flash back Table 1. Set the properties of a table ALTER TABLE AAA enable row movement; 2, restore the table data to 2 minutes ago Flashback table AAA to timestamp sysdate-(1/24/3600) *

Oracle Recovery Management (RMAN) has a number of features that can be used to help with the backup and recovery process, which has two versions of the command line and GUI. Typically, RMAN performs and standardizes the backup and recovery processes

Method Find Symcjit.dll, find two places, both JRE (Java Runtime Environment) Rename the two files to Symcjit_.dll and install them, which can be completely normal. Install hardware (already installed properly): Server:dell PowerEdge 2600 Dual

One. Backup of data files, control files, and log files 1. The server has installed the operating system, and Oracle has also been reloading. If the restored Oracle is the exact same structure as the previously corrupted database, then the recovery

The architecture of an Oracle Data warehouse can be divided into three tiers: Data acquisition Layer: Oracle database Enterprise ETL OPTION + Oracle database data Quality option in Oracle database 10g the same software is designed from data model,

1.oracle How does the execution of an SQL statement manage concurrency and recovery control? A syntax-compliant SQL statement that defines the operation of the database. At the moment this operation is executed, a data state for the database is