Oracle

Install and use the Oracle Instant Client on the Oracle website as needed ( http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Download the corresponding Instant Client Version package, the description of each

Oracle built-in function analysis SQL single record function 1. ASCII returns the decimal number corresponding to the specified character. SQL> select ascii ('A') A, ascii ('A') A, ascii ('0') zero, ascii ('') space from dual; a zero space ---------

ORA-24324: Service handle not initialized, not allowed, closing-connection not allowed problem C:/Documents and Settings/Administrator> sqlplus "/as sysdba" SQL> startup mount www.2cto.com ORA-01081: unable to start ORACLE that is already

Oracle architecture database structure oracle database consists of two parts: database and instance database: a series of physical files that specifically store data and related objects. Instance: refers to a series of operating system processes and

Application of Oracle triggers in MIS development this article introduces the concepts and types of oracle triggers, summarizes the application of oracle triggers in MIS development, and provides examples for reference. 1. introduction www.2cto.com

Oracle Data Pump tool series: how to reinstall the DataPump EXPDP/IMPDP tool and how to reload the Datapump utility EXPDP/IMPDP this article applies to OracleDatabase-Enterprise Edition-Version 10.1.0.2 to 11.2.0.3 which may need to be reloaded in

In PLSQL Developer, the complete server of Oracle9i is installed on the machine that modifies the Oracle Home setting method, and an Oracle10g client is also installed, in this way, my machine has two Oracle Home instances at the same time. During

Batch refresh remote materialized view (standby) 1. create a remote database connection create database link MDM connect to MDM identified by mdm using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 172.17.11.1) (PORT = 1521)

All about Oracle IMP/EXP import/export is the oldest two command line tools survived by ORACLE. In fact, I never think Exp/Imp is a good backup method, the correct statement is that Exp/Imp can only be a good dump tool, especially in small database

The SQL * Plus copy command is used to process mass data replication. For data replication at the database TABLE level, the most common method is CREATE TABLE AS (CTAS. In fact, the copy command under SQL * Plus can do the same job, and it is better,

Rman backup script rman shell script editing is first tested in rman to check whether the backup is normal. The statement is being judged. Backup script sh command export target/msglog =/oracle/ora10g/rmanbak/bakl0.log export file

Oracle left join... ON... AND... and left join... ON... WHERE... difference about left join... on... and... and left join... on... the difference between where is that many online statements are about left join... on... and ..., and conditions only

Pl/SQL developer open the table garbled. In pl/SQL developer, view the table structure. The table structure comments are all ???, It is normal to view the table structure directly in the cmd window, which indicates that it is a problem with pl/SQL

1. What is sqlplus? Sqlplus is an interactive tool for batch query. Sqlplus is installed for each oracle database. Sqlplus works in the command line mode. SQL * Plus has its own command set and environment. Sqlplus provides users with a way to

CBO learning --- Chapter 1 -- What do You Mean by Cost Chapter 2 meaning of Cost (What do You Mean by Cost ?) Two meanings of Cost (Cost/Cost): (1) the magic number generated by the explain plan tool (2) the actual resource consumption of SQL

Oracle 11g rac ocr and db_unique_name configuration relationship description 1. Problem 1: the following error is found in the alert log of RAC standby: SUCCESS: diskgroup DATA was mountedERROR: failed toestablish dependency between database dave_st

Yum-y install oracle-rdbms-server-11gR2-preinstall this method oel6.4 experiment through #!/etc/bash  #1. Load the DVD installation disk. Note that the drive path can be df-lh and/dev/sr0 is displayed in my

[Oracle] Data Pump detailed tutorial (1)-Overview starting from 10 Gb, Oracle provides more efficient Data Pump (expdp/impdp) for Data import and export, old exp/imp can be used, but it is not recommended. Note: expdp/impdp AND exp/imp are

Oracle GoldenGate series: ora-01031 errors when using Oracle asm api dblogreader today test GoldenGate on your new Oracle ACFS file system, the following error is reported when the extract process is started: 14:58:39 ERROR OGG-00446 Opening ASM

Today I'm using Oracle Data to import and export imp/exp sp2-0734: Unknown command starting with \ 'Imp ignores the default classification of the remaining lines, so let's look at the solution below. Sp2-0734: Unknown command starting with 'Imp