Oracle

  Primary master database IP: 192.168.50.4/24 Dbname: ora10g Database Version: 10g R2 Operating system version: rhel6.0 64-bit Standby physical standby Database IP: 192.168.50.230/24 Dbname: ora10g Database Version: 10g R2 Operating system version:

In oracle/PLSQL, the substr functions allows you to extract a substring from a string. The syntax for the substr function is: Substr (string, start_position, [length])Note:String is the source string.Start_position is the position for extraction.

Oracle applications framework is an oracle HTML-based business development platform. OAF includes a series of middleware running services and JDEVELOPER-based design-time extension tools.In the first few years of Internet development, the software

Method 1. Import text files to ORACLE Create table hkh_August not dial(PHONE_NUM VARCHAR2 (11))ORGANIZATION EXTERNAL(TYPE ORACLE_LOADERDEFAULT DIRECTORY TEMPAccess parameters (records delimited by newline fields terminated ',')LOCATION ('hkh _ 181.

Before installing clusterware, the following error occurs when you check the installation environment: User equivalence unavailable on all the nodes: Search for the solution on the Internet as follows: Run the following command under the root

After installing oracle yesterday, I first got an error. I didn't set the oracle environment variable. I re-installed it again. Now, there are several minor problems, first, garbled characters may occur in sqlplus, and sqlplus cannot use backspace

Common oracle function summary ******************** **************************************** **************************************** SQL Group Functions (num can be a column or expression )*(Null values are ignored, default between distinct and all

Oracle startup small problem Question: ORA-12560: TNS: protocol adapter error Fix: 1. Listening service not started. On the windows platform, perform the following operations: Control Panel --- management tools --- Service to start the

Change the protection mode of dataguard View the current protection mode: SQL> select protection_mode from v $ database; PROTECTION_MODE--------------------MAXIMUM AVAILABILITY prepare to change protection mode to maximum performance mode: On the

[Oracle] SQL * Loader detailed tutorial (2)-input sqlldr in command line parameters without any parameters, the simple description of all command line parameters and their default values are displayed. (You can also use this method to quickly query

Oracle listener cannot be started. 1. Connection host string, says no listener SVRMGR> connect internal/oracle@orcl; ORA-12541: TNS:no listener SVRMGR>  2. Run the listener, indicating that the protocol-specific component of the address is

[Oracle] online table redefinition-modifying table definitions (DDL) in a 7*24 online production system is very painful, if you use the alter statement directly, an exclusive lock will be placed on the table. That is to say, during this period, all

For execution of dynamic SQL in oralce -- Execute dynamic SQL CREATE OR REPLACE FUNCTION fun_checkguaranteetype (TranId varchar2) return varchar2 is V_result varchar2 (1000); Begin declare zhiyavar NUMBER; diyavar NUMBER; dabaoren NUMBER; v_ SQL

Oracle SQL advanced programming learning notes (I) Core SQL statement 1, select statement execution sequence 5 SELECT 1 FROM 1.1 FROM JOIN ON 2 WHERE 3 GROUP BY 4 HAVING 5 ORDER BY  (1) first

PROTECTION_MODE is UNPROTECTED at standby database analytics database version SQL> select * from v$version;BANNER--------------------------------------------------------------------------------------------------------------------------------Oracle

This document describes how to enable and disable the Oracle archive mode for a database. 1. shutdown normal or shutdown immediate disable database oracle Training 　　1 .oracle@jumper oracle]$ sqlplus "/ as sysdba"　　2.SQL*Plus: Release 9.2.0.4.0 -

X $ bh X$BH Fixed Table Buffer Cache Diagram Column Type Description~~~~~~ ~~~~~ ~~~~~~~~~~~ADDR RAW(4) Hex address of the Buffer Header.INDX NUMBER Buffer Header numberBUF# NUMBERHLADDR RAW(4) Hash Chain Latch AddressSee . ADDRLRU_FLAG NUMBER 8.1+

Oracle Partition Table exchange principle oracle partition exchange operation is very fast, then what is the principle? Let's create an experiment: SQL> create table test (id number (3); the table has been created. SQL> insert into test values (1); 1

Solve oracle database connection exceptions caused by IP changes "ORA-12541: TNS: no listening program" before the local machine installed oracle, several databases are commonly used, no exception. But today I use PLSQL to connect to the database,

To modify the Data Type of a table field in ORACLE, you need to use a backup field to change the table as follows: Alter table tablename alter column colname newDataType  For example: Alter table mytable alter column mycol1 int default 0  Later,