Oracle

Oracle under Windows, when an instance is started, it writes boot information to the Event Viewer of the Windows operating system-the application section, and this write behavior cannot be disabled with Oracle parameters or other means.If the Event

A problem with an Oracle database that is deployed on IIS that WebService connect the English character set is "not registered on the local computer" msdaora.1 "provider" with the following solution:Cause: such as an error, the 64-bit system is not

This article from the following aspects of the concept and operation of the partition table: 1. Table space and the concept of partitioned Tables 2. Table partitioning's specific role 3. Table partitioning's advantages and disadvantages 4. Table

I. Overview of schedulingHere I see an overview of scheduling that feels better than mine, but is limited to the overview section, other parts I think I speak better than him, so the following things happen:Gorgeous reprint of ***********************

I want to do two sets of RAC between the data guard, because Datafile,controlfile, even archivelog are stored in ASM, the direct copy of the data is a bit unrealistic, ASM disk is always to use, so want to do from a library Rman full backup, Then

Oracle data import and export imp/exp is equivalent to Oracle data restore and backup. The EXP command can export data from a remote database server to a local DMP file, and the IMP command can import the DMP file from a local to a distant database

Example of a Scott user's EMP table----Increase PolicyBeginDbms_fga. Add_policy (Object_schema = ' SCOTT ',object_name = ' EMP ',Policy_name = ' Mypolicy1 ',Handler_schema = NULL,Handler_module = NULL,Enable = TRUE,Statement_types = ' INSERT, Update,

Pick: Solution for insufficient swap space when installing Oracle under Linux Workaround for installing Oracle on Linux with insufficient swap spaceThere are two ways to increase the swap space: Strictly speaking, there is only one way to increase

Single-record functions in SQL1.ASCIIReturns the decimal number corresponding to the specified character (note: is a character rather than a string);Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;A A ZERO

"Deep analysis--eygle" study notes1.2.3 PGA Management:[Email protected] Sql>show parameter area_size NAME TYPE VALUE---------------------------------------------------------- ------------------------

 1 installation Knowledge of Oracle (oracle10g and oracle11g version differences ) :A the installation directory should not have Chinese and white spaceB oracle10g support winxp does not support win7,8 and vista;oracle11g supports all

Account Environment: AIX7.1 + Dual-node Oracle RAC 11.2.0.3Since this set of RAC is not installed in its own department, it is installed by the development department and is now managed by the Operations section, and customers need to command the

Note: This article is excerpt from Zhang Xiaoming Oracle RAC: Cluster high availability backup and recoveryBecause the cluster environment needs multiple computers to work together, to achieve the ideal state, we must consider the new challenges

method One: Use Sqlplus# # #64位: [[email protected] ~]$ sqlplus/as sysdba sql*plus:release 11.2.0.3.0 Production on Fri Oct 318:44:05 Copyri Ght (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition release11.2.0

Oracle A lot of version number, first look at the 11g version number description:Attention: after the Oracle 9.2 version, Oracle's maintenance release number is changed at the second digit bit. And before that is in the third digit digit.1. Major

Sqlldr is used to quickly bulk import data,The example steps are as follows:1. Determine connection examples for Oracleusername/[email protected]I'm using:system/ World @ LOCALORCLThe SID is an example of a connection, the service naming in Net

Statement **********************************************Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.Please leave a message or email ([email

PLSQL remote connection to Oracle server, plsqloracle Server Only one remote connection method is introduced here, that is, the Oracle client and PLSql tool are installed on the local machine, and the server is installed on the virtual machine or

Oracle Automatic Diagnostic archives (ADR), automatic diagnostic workflows, and ADRCI tools. Automatic diagnosis workflow: With a memory tracking tool that is always on, the database component can capture diagnostic data when a serious error occurs

Listener. ora adds the listening port and listener. ora listens. A simple listener. ora # Listener. ora Network Configuration File: d: \ app \ zyd \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ listener. ora # Generated by Oracle configuration