Oracle

This article makes it possible to discover some of the problems of backup during the recovery process by using a complete backup of Oracle 10g RAC Rman for a different machine recovery process. such as the redundancy of the Regulation log, control

When the Oracle database is closed, the shutdown immediate is not closed after the command, the alert log is viewed, and the log is prompted after the wait period:Shutdown:waiting for active calls to complete.The reason is that some processes cannot

ExportIf you export, select the query results in the query results in Pl/sql SQL window and right click on the selection of COPY to Excel Import Method OneThe following article is mainly about how to use Sql*loader to export Excel-related data to

First, simple query SQL (structured query Language) Structured Query language is a database query and programming language for accessing data and querying, updating, and managing relational database systems. ANSI (American National Standards

Environment Linux 5.8 10.2.0.5 RAC, two nodes can only mount a node, if you try to mount another node on the report ORA-01105 and ORA-01606 error Database version Copy Code code as follows: Sql> select * from V$version; BANNER

The recent merger of Oracle and Sun has been a major concern for many developers, mainly because of the potential for new changes in the MySQL database, which this week made 10 promises to MySQL users, developers and customers. Oracle has had a

Article Summary: Oracle is a database platform, and some projects use Oracle's database replication technology, which also encounters some problems, so here I have a personal understanding of Oracle's replication technology, hoping to help the

A session can start multiple transactions, which are sessions, meaning one connection at a time. A transaction is a unit of action that either succeeds or fails and has no intermediate state. Multiple transactions can be completed in a session.

The general To_char is such a to_char (Sysdate, ' yyyy-mm-dd hh:mi:ss am '), and there are several points of use for the book To_char (sysdate, ' DD ') see what date it is today To_char (sysdate, ' ww ') view this is the first few weeks of the

Oracle Database 11g defaults to a system-defined moving Window Baseline that corresponds to all AWR data for the AWR retention period. Only one moving Window Baseline can exist. The system-defined moving Window baseline is the current awr

The original knowledge of the index only knows that the index can be based on one or more columns, the B-tree index does not contain NULL, but in some cases we need to find some data through the where column name is NULL, when the database uses the

Oracle to MySQL test has always been a garbled problem can not be resolved, and then exchanges with colleagues, he said that Oracle use OGG 11g version, MySQL use ogg 10g version can solve the garbled problem, at first I still doubt, because I think

RAC, Data Gurad, Stream are three tools in the Oracle High-availability system, each of which can be used independently or in conjunction with each other. Their respective emphasis is different, the application scenario is also different. RAC its

"Guide" This article describes the considerations for MySQL to Oracle program migration. There are many applications, just started with the MySQL database can basically achieve a variety of functional requirements, with the increase in the number

For some time did not engage in Oracle, recently to others in Win 7 under the Oracle 10g, special record memo.Using Http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip, Direct Thunder can be downloadedAfter decompression,

First, go to Oracle's website to download an Oracle 11g Client (My 11g Oracle), but you need to apply for an Oracle account before you can download it.Current: http://www.oracle.com/technetwork/topics/winsoft-085727.htmlThis is a green version of

1 Recover database using Backup Controlfile2 Recover database until cancel3 Recover database using Backup controlfile until cancel;4 Recover database until cancel using Backup controlfile;This article mainly introduces the following four kinds

First, demand analysisboth SAP and Oracle EBS are the world's top ERP products and are favored by many customers. However, due to the large system, high price and different positioning, customers often face the following confusion in the

Microsoft (China) Co., Ltd. announced that in March 2001, Microsoft SQL Server 2000 received three consecutiveGrand Prize, highly scalable data warehouse, and business intelligence features won deep recognition. In April 2001, 2000 million

The ORACLE tutorial is the SH file of the logical backup of the Oracle database.Full Backup SH file: exp_comp.shRq = 'date + "% m % d "'Su-oracle-c "exp system/manager full = y inctype = complete file =/oracle/export/db_comp $ rq. dmp"Cumulative