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

This section mainly describes the workflow of communication, as well as some related features (processing logic), the content is equally boring, but think twice about the value of reading. In the entire streams replication environment, the

Sqlloader export Excel data to Oracle 1. Create Sql*loader input data required by the file, are saved to C:\, edited in Notepad: Control file: Input.ctl, the contents are as follows: Load data--1, control file identification InFile ' Test.txt '--

Oracle 11g Dataguard Snapshot standby database functionality, which places the standby in open read/write state and simulates the test in the main library of the production environment. When the standby snapshot standby task completes, you can

How to efficiently import Excel into Oracle? And the first two days of sqlbulkcopy import into SQL Server correspondence, Oracle has its own approach, just slightly more complicated. That is using Oracle's Sql*loader feature, and SQLLDR only

The case of PL/SQL programming specification As in SQL, Pl/sql is case-insensitive. Its general guidelines are as follows: Keywords (BEGIN, EXCEPTION, end, IF THEN else,loop, End LOOP), data type (VARCHAR2, number), internal functions (least,

Triggers enable consistency and completeness of data between tables. When a base table is modified, the corresponding trigger is automatically executed. Operations on table data are inserted, modified, and deleted, and the corresponding triggers for

oracle| Process | statement Starting in 07, a new company, the database using oracle10g, has been using Informix and Msserver, feel the Oracle function is really strong, more than Informi and Msserver are better, the architecture and management of a

oracle| Data | database | questions This article mainly describes how to deal with the problem of bad blocks in the Oracle database, for the bad block produced on different objects, the processing method will be different, this article will make a

Oracle There are more than n such articles on the Internet, but I installed in the time, no article on the internet for me, and finally I almost browsed all the similar documents after, summed up the following installation methods, I hope you can

oracle| Conversion | string How to implement the ASC string and 16-string conversion in Oracle Welcome everyone to communicate with me: Enhydraboy enhydra_boy@tom.com Welcome to reprint, please keep this statement, thank you! The following is the

Oracle 2Gb or not 2gb-file limits in Oracle (part II) Exporting (export) and 2Gb 2Gb size of exported file When most versions of export are written, the default file action APIs are used on the creation of export files. This means that on

oracle| optimization Oracle Optimizer: Migrating to using the cost-based optimizer-----series 1.3 3.2.3 Available CBO mode The CBO has two modes of operation: All_rows and First_rows. The goal of First_rows is to return rows as quickly as

oracle| optimization Oracle Optimizer: Migrating to using the cost-based optimizer-----series 1.4 3.2.3 Minimum Requirements The minimum requirement for CBO is to set the optimizer mode to Frist_rows or all_rows (or choose) and generate statistics

Hints translated into Chinese is the hint, implied meaning, it is in the database role is to change the execution of SQL statements, you can use hints to force SQL in the way you set up to execute SQL, generally used to do performance diagnostics

A database version Leo1@leo1>select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle database11g Enterprise Edition release 11.2.0.1.0-64bit Production Pl/sql

Redhat9.0 is a very good Linux distribution, with good Chinese support and rich application software, so that the author, including a lot of Linux with the home fondle admiringly. However, due to the high Redhat9.0 version of GCC, some compatibility

Database concurrent access, where two or more users access the same data at the same time, is the biggest problem for the database engine to design and implement a moderate response. A well-designed, performance-capable database engine can easily

"Guide" This paper presents the principle of flashback function, describes the use of Oracle 9i or Oracle 10g Flash-back function to recover accidental loss of data methods. Objective Human error is one of the important reasons for the failure of

Oracle's Plsql CREATE OR REPLACE Package chapter_13 asTYPE RS is REF CURSOR;Procedure founder (ofields out RS);EndCREATE OR REPLACE Package Body chapter_13 asPROCEDURE founder (Ofields out RS) isBEGINOpen Ofields forselect * from person;End founder;