Oracle

This article mainly discusses the following sections: How to view query Oracle character set, modify settings character set, and common Oracle UTF8 character set and Oracle exp character set issues. One, what is the Oracle character set An Oracle

Finally put OCP DBA's course all finished, tired Ah! Overall Oracle certification is worth the test. I have CCNP, MCSE certificate, but through the DBA examination, feel not only deepened the understanding of modern databases, but also enrich the

Apache|mysql|oracle| Raiders to see many online users of PHP, JSP, Sybase, Oracle, Apache and other aspects of the installation experience, found that many are repetitive and not comprehensive, According to my long-term summary of all kinds of

Mysql|oracle This is my comparison's installing and getting started with Oracle 10g, PostgreSQL 8 and MySQL 5. This is what I consider the comparison of the ' art for three categories to db:commercial vs. Academe vs. Internet Model. This is a

This article describes how to use SQL loader to insert data from an Oracle database into an Excel file. Implementation purpose: Insert data from an Excel file into an Oracle database Implementation steps: 1. Open Microsoft Excel 2000 2, file (F)

Os:redhat as 4 Oracle:oracle10gr2 The customer presents a request to demonstrate the recovery of RAC DB to single-instance, and their purpose is to verify the backup effectiveness of the production environment Here are the ideas and the main

These days encountered two problems, are very wonderful, distressed for three days, the final positioning out.Problem one, inserting data through PL/SQL developer to a remote Oracle database server, querying data through PL/SQL developer queries,

Directory Cache Fusion principle What is Cache Fusion? What is high availability The difference between FAILSAFE and RAC RAC and OPS differences Differences between hot standby, RAC, and Data guard for dual machines

CREATE TABLE as SELECT * FROM and insert to select from two table copy statement differences[SQL]View PlainCopy Create table targer_table as select * from source_table INSERT INTO target_table (column1,column2) select Column1,column2

Today, when doing data extraction, we find that there is a data volume of business table reached 5000W, so we want to change this table to partition table. The partition table is a bit like this:1. Improve query performance: Queries on partitioned

Application of incremental backup in recovery phase, no longer restore phaseUnderstanding the Database Settings table:Sql>desc database_propertiesName Null? Type----------------------------------------- --------

Recently depressed character set July 31, 2014 16:32:58This article focuses on the following sections: How to view queries for Oracle character sets, modify set character sets, and common Oracle UTF8 character set and Oracle exp character set issues.

Objective:Morning to work, development to inform the database connection is not, say is reported memory overflow, check memory free space is really insufficient, then will high memory process end, but after the end is not connected, restart the

RAC pre-Installation for NFS on Linux (vi) Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of

Quickly view information such as output file or log for a request in ORACLE EBS On the project, there are often requests to report yellow and other issues reflected on the technical consultant side, but due to certain restrictions, sometimes even

Oracle Data Integrator 12CR1 (12.1.3.0.0) installation process download installation filesOracle Data IntegratorCR1 (12.1.3.0.0) Http://download.oracle.com/otn/nt/middleware/12c/121300/fmw_12.1.3.0.0_odi_Disk1_1of1.zip Oracle Fusion Middleware

This article mainly discusses the following parts: how to view and query Oracle character sets, modify and set character sets, and common Oracle utf8 and Oracle exp character sets. 1. What is the Oracle character set? The Oracle character set is

I. Installation 1. Download The XE installation package from the Oracle official website (it seems that Windows only has 32 bits and Linux only has 6 bits) and decompress the package. 2. Double-click setup.exe to start the installer. Do not click

The ORACLE tutorial is the basics of Oracle PL/SQL language. PL/SQL is an extension of ORACLE's standard database language. ORACLE has integrated PL/SQL into ORACLE servers and other tools, in recent years, more developers and DBAs have started to

Recently a lot of friends consulted 12.1.0.2 and later versions using oradebug to modify scn failed, here to do a test under normal circumstances can not be modified (oradebug poke reported ORA-32519 or ORA-32521 ), A series of modifications are