Oracle

Oracle data recovery from the recovery type, cast aside the specific files, the total can be divided into two major types of recovery, one is full recovery, one is not full recovery. In fact, once you are familiar with the Oracle architecture, there

Second, the OMF management of the log file Log file management parameters: Db_create_online_log_dest_n Db_create_online_log_dest_n:oracle the default path when you create an online log file and a control file without explicitly specifying a path -

To use an Oracle database, the user first has to establish a connection to the database. For database connections, Oracle offers two solutions: private and shared connections. In most cases, we use a private connection. For a private connection,

SQLLDR Tools The Sql*loader client tool is Sqlldr, enter SQLLDR at the command line of the operating system, followed by no arguments, will display Help information as follows (a simple description of all command-line arguments and their default

1. Introduction to Basic table space A. system table space Main storage data dictionary and Internal system table base table To view the SQL of the Data data dictionary SELECT * FROM Dict To view the SQL for an internal system table SELECT *

First, Trigger 1. Triggers are stored as separate objects in the database, 2. Triggers do not need to be invoked, it is triggered by an event to run 3. Triggers cannot receive parameters --Application of Trigger For example: NET, net, Facebook,

Create a dblink, named Dblink_name, from a database to the B database, the B database IP is 192.168.1.73, the port is 1521, the instance name is Oracle, the login name is tast, and the password is test. A menu method: Open Plsql, click "File"-"New"

Oracle 11g is the latest database software launched, Oracle 11g has more than 400 functions, after 15 million hours of testing, development work volume reached 36,000 people/month, equivalent to 1000 employees for continuous research and development

The Oracle tutorial being looked at is: analysis and resolution of Oracle common error codes two. -------------------------------------------------------------------------------- P align= "Justify" >ora-01578:oracle data block corrupted (file #

Oracle Cloud Control 12c the entire installation is more complex, light installation path selection, login password, port number and many other configurations are confusing, dizzying. This article describes how to obtain installation after

The basic Concept Character set (Character set): is a collection of all abstract characters supported by a system. Characters are the general name of various words and symbols, including the national characters, punctuation marks, graphic

Copy Code code as follows: -Oracle takes the SQL from Monday to the weekend This takes the first days of the week, starting with Sunday. Select To_char (to_date (' 20130906 ', ' yyyymmdd '), ' d ') from dual; --Result: 6 Note: 2013.09.06

Whenever we encounter SQL-related performance, we always need to collect 10046 to view and diagnose the problem.Since 10046 the true response of the SQL statement executes when the real information, parsing, execution, acquisition time consumption,

Recently, the company leader told the next product, may involve Oracle database, formerly used most is MSSQL, some time ago learned MySQL is also a little used. Oracle has not been contacted. Should have done for me before. NET development, so data

Starting with the Oracle8i version, in Oracle databases, where there is no special need for application, database monitoring does not need to be configured, and Oracle calls this method dynamic registration. The so-called dynamic registration,

I. Overview Some time ago, a DBA friend after completing the Rebuild table (rename) work, the next morning business is not operational, the data can not be inserted restrictions and errors, later analysis found that the reason for the error is the

First, error checking [Oracle@srtcreen ~]$ Ggsci Oracle Goldengate Command Interpreter for Oracle Version 11.1.1.1.1 oggcore_11.1.1.1.1_platforms_110729.1700 Linux, x64, 64bit (optimized), Oracle 10g on June 29 2011 19:43:29 Copyright (C) 1995,

I've often seen people ask this question, I've set up multiple indexes on the same table, why does Oracle choose one at a time and not use multiple indexes at the same time? Generally speaking, the common access to the same table more than two

1. All nodes as RootRPM-IVH oracleasmlib-2.0.4-1.el6.x86_64.rpmRpm-qa *asm*kmod-oracleasm-2.0.8-13.0.1.el6_8.x86_64oracleasm-support-2.1.8-1.el6.x86_ 64oracleasmlib-2.0.4-1.el6.x86_64Rpm-qa cvu*Cvuqdisk-1.0.9-1.x86_642. After loading the required

The problem originated from a 12c database of the customer and needs to be started to the non-real time apply mode, but the execution is found:Alter database recover managed standby database cancel;Alter database recover managed standby database