Oracle

DUAL is a table automatically created by Oracle Database along with the dataDictionary. DUAL is in the schema of the user SYS, but was accessible by the name DUALto all users. It has one column, DUMMY, defined to be VARCHAR2 (1), and contains oneRow

1, separate download instantclient_10_2, in the cloud disk has2. Preference configuration path in Plsql3, E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN in the Listener.ora# Listener.ora Network Configuration

Previously on the 10g database, if the binding snooping caused the execution plan is slow, want to clear the execution plan of a SQL, let it hard parsing, for a long time did not find a direct operation share pool method (total cannot alter system

1. Stop standbySelect process, status from V$managed_standby;---check if the repository is being restored in the application logALTER DATABASE recover managed standby database cancel;Shutdown immediate;  2. Switch to read-only mode-----switch from

First, connect theSql*plus:release 12.1.0.2.0 Production on Thu February 12 15:40:422015Copyright (c) 1982, Oracle. All rights reserved.Please enter user name: SystemEnter Password:Last Successful login time: Thursday February 12 2015 10:26:40 +08:00

Transferred from: http://database.51cto.com/art/201010/231561.htmOracle queries are sometimes constrained by conditions such as capitalization. Here's a way to implement an Oracle query that ignores case, so if you're interested in Oracle queries,

Today just in their own computer installed oracle10g, computer is the Win7 system, the computer comes with the system. After a successful install, enter Sqlplus prompt under cmd: sp2-1503: Unable to initialize Oracle call interfaceSP2-1503: Unable

One, the Oracle data dictionary is composed of the following views mainly:1.user ViewUse User_ as a prefix to record information about user objects2.all ViewAll_, which is used to record the information of the user object and the object information

Control file is one of Oracle's physical files that records information such as the name of the database, the location of the data file, and so on. The importance of the control file is that once the control file is corrupted, the database will be

Yesterday in the middle of the night to install a rh5+oracle version, during the encounter a few things, stated as follows, as the basis. 1. Before installation, you need to configure the kernel parameters, can refer to the Oracle Official document

1. Hardware environmentIBM X3850 X5 Server 4 CPU 10 cores2 Software EnvironmentWindows R2 Enterprise Edition, Oracle 11.2.0.1Today in the customer site to install the Oracle process is smooth, software, monitoring are installed, and finally in the

Including:centos6.5 ORACLE11GR2 Dataguard InstallationDataGuard Primary and Standby switchover role switchingData Synchronization Test1. Start the main library normally$sqlplus/as SYSDBASql>startup2. Start the Standby library$sqlplus/as

Recently found in Javaeye many comrades on the optimization of SQL seems to know very little, recently summed up a few for reference only, but a few may depend on the situation, most of it is quite effective.Note: The following (inefficient) and

Oracle job timed execution of stored procedures One: simple test job Create a process case:1 , first create a job_test table, field is a Date FormatSql> CREATE TABLE Job_test (a date);Table

This article is mainly a summary of the problem, will be updated continuously.1. When executing environment *env = Environment::createenvironment (), throws an exception, the code is ORA-32104, but there is no error messageThe reason is to use the

There are requirements as follows:Now it's time to tb1 the song field. The condition is to go to Tb2 to find songs sung by the same artist, randomly populated with the song name field in TB1A singer not only sings a song, so TB2 is a collection of

Import large amounts of data into the database, dbf import oracle, csv import oracle In Excel 07-2003, a worksheet can have a maximum of 65536 rows and a maximum of 256 columns. In Excel 2007 and later versions, a worksheet can have a maximum of 1048

How to import additional fields in Oracle as null values Q: We have migrated our Oracle database to a new environment. Some customer tables exist in two databases at the same time, but those tables in the new environment have some additional fields.

Oracle uses triggers to implement auto-increment Columns Oracle uses triggers to implement auto-increment Columns Oracle does not have the auto-increment function. mysql and sqlserver use auto_increment and identity () to implement auto-increment

[ORACLE] processing of oracle string objects 2.1 char field, varchar2 Field (1) Defining the field length char (10) indicates that the field can contain 10 English characters (regardless of the encoding method, do English characters occupy 10 bytes ?