Others

row to column, column change, decode , Case ... when ... then. Case ... when ... then. [when ... then] else ... end Original: revisit sql--row and column change Row to column, column change is the problem we often encounter in the

RT, the following exceptions often occur when using normal means for multiple data source configuration: (long interception, lowest resolution)   WARN (settingsfactory.java:117) [Containerbackgroundprocessor[standardengine

Data Block ( Data Block ) Principle of in-depth analysis What is a data block Data Block (Oracle Data Blocks), the Oracle block size is typically an integral multiple of the operating system block. This article is referred to as "block", which

First, we download oracle11g at the official website, the link is as follows: Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Note the number of system bits and files Two files are downloaded, the process may be

  --I. Export--1, create directory creation directory DIR_DP as ' D:/ORACLE/DIR_DP '; --Note:--DIR_DP: Name 2nd 3rd step to use-' D:/ORACLE/DIR_DP ': DIR_DP specific path--2, authorized Grant Read,write on directory DIR_DP to Zftang; --Description:

When doing a backup of a EXPDP data pump, it is often the case that some temporary tables are large, but the data does not need to be backed up. We need to get rid of these tables to avoid wasting unnecessary disk space. We have the need to exclude

Original link: http://www.cnblogs.com/dreamer-fish/p/3445887.html 1, download the Oracle 11g R2 version of Windows, the official download address is as follows: Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip Http://

OCP Paper Certificate application procedure Prerequisites, you have to attend the Oracle Training partner organization Training, and passed the certification exam, about training This Oracle company is documented, if there is no training direct

1. Change the archive path In oracle10g, the default archive path is $oracle_base/flash_recovery_area. For this path,Oracle has a limitation that only 2G of space is available to the archive log by default, and you can use the following two SQL

oracle11g error ORA-39002, ORA-39070, ORA-39087 Scenario Description When using data pump to import data, Report ORA-39002, ORA-39070, ORA-39087 three errors. SQL statement used when importing data: IMPDP ' sys/123@test as Sysdba '

Java.sql.SQLException:Io exception: Connection refused (description= (tmp=) (vsnnum=153092352) (err=12505) (error_stack= ( Error= (code=12505) (emfi=4)))At Oracle.jdbc.dbaccess.DBError.throwSqlException (dberror.java:134)At

Disclaimer: This is a reference to Secooler's "Data Migration replication--network_link parameters between different users of the same database instance" (http://space.itpub.net/519536/viewspace-631571), thank you. In actual development and

In OracleOf 11gVersion is introduced in the Regexp_countfunction, use this functionOK Statistic stringappear in number of, small view. 1.regexp_count function Syntax Reference Regexp_count (Source_char, pattern [, Position [, Match_param]]) 2.

1 Floor: The data in the table is deleted every night (around 1.5 million), and the primary key index is on the table.When this data is deleted, the index table space that it occupies is not released, so the rebuild is used,Can rebuild free up space?

Votedisk Backup [grid@rac1 ~]$ crsctl query CSS Votedisk # state file Universal Id file Name Disk Group-- ----------------------------------------1. ONLINE 1b94d29855d64fb1bfc51f95a6c97b36 (/DEV/RAW/RAW3) [Ocr_vote] 2. ONLINE ae850f1de5c04f8cbfac1b19

The rapid development of software everyone is accustomed to the use of visual interface, for Oracle we usually use the most likely is plsql developer, Sqlplus ... , and exp/imp Two commands can be said to be the most commonly used command in Oracle.

Environment description System for CentOS 6.0 192.168.255.128 = "Server01192.168.255.130 = "Server02192.168.255.131 = "Server03 The/etc/hosts file has these IP and domain name Mapping relationships Configure SERVER01 to access Server02 and server03

original works, from the "Deep Blue Blog" blog, Welcome to reprint, please be sure to indicate the following source, otherwise held responsible for copyright liability. Blue

User, group, and software requirements perform the following actions on both library servers: Set up the DBA group, the group ID number is recommended 101, and the group ID number of the two library servers should be the same. To see if the Hagsuser

There could be three different reasons.1. The IP address was written incorrectly.2. Firewall not closed3. The last one might look at the settings for the listener file Listener.ora:4. ' LISTENER =(Description_list =(DESCRIPTION =(address = (PROTOCOL