Oracle

Ext.: http://www.2cto.com/database/201210/163979.htmlTemporary tables: Like normal tables, there is a structure, but the management of the data is not the same, the temporary table stores the transaction or the intermediate result set of the session,

Change the Oracle archive path and archive mode   in oracle10g and 11g versions, the Oracle default log archive path is the Flashback recovery area ($ORACLE _base/flash_recovery_area). For this path, Oracle has a limitation, that is, the default is

SUBSTR () and SUBSTRB () differ in the interception of Chinese characters, a Chinese character may account for 2 or 3 characters, substr () the length of the Intercept refers to the length of the string, the length of the SUBSTRB () is the length of

The first step is to make a backup first#!/bin/shExport oracle_base=/home/oracle/Appexport Oracle_home=$ORACLE _base/oracle/product/11.2.0/Dbhome_1export Oracle_sid=Orclexport Ld_library_path=$ORACLE _home/bin:$PATH:$HOME/bin//Note is a colon RQ= '

creation and operation of Oracle database partitioned tablesSummary: In a large number of business data processing projects, you can consider using partitioned tables to improve the performance of the application system and facilitate data

Recently, after installing the Oracle 10g RAC on the client based on SuSE SP3, I received an error message when Clusterware execution/u01/app/crs/root.sh was installed, Failed to upgrade Oracle Cluster Registry configuration because the current

Reprint Please specify source : http://blog.csdn.net/guoyjoe/article/details/386848191. Get the library cache Latch(1) The text of the SQL statement was not found in the handle of the parent cursor: SELECT * from Gyj_t1 where id=1;2. Release Library

Oh, spent one hours, around the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's shoes to improve the installation efficiency. Oh.

Simple Introduction to Oracle in RowNum and Row_number () use, example demo.Reference: http://www.cnblogs.com/zjrstar/archive/2006/08/31/491090.htmlLet's start by creating an example to illustrate, stealing a lazy, using the child's shoes

There is a recent industry project that requires large data to be imported from files to Oracle. We use Oracle 's sqlldr to import data, which is too long to import when the amount of data is large: Importing a table of 8 Thousands records takes 2.5

Browse through Oracle's official web pages and unofficial PPT to get a quick overview of the high-availability scenarios Oracle offers.1. RACRAC, Real application ClustersMultiple Oracle servers form a shared cache, and these Oracle servers share a

Defined:A stored procedure (Stored Procedure) is a set of SQL statements that are compiled and stored in a database in order to accomplish a specific function. The user executes it by specifying the name of the stored procedure and giving the

A: PrefaceToday, I write the cursor for the second time, I wipe, I think I need a great improvement in the database. There are three problems today, the first is the problem of data splitting in Oracle database, which I use REGEXP_SUBSTR to solve,

Oracle error ORA-00604 recursion SQL Level 1 error ora-00942 table or attempt to not exist ORA-06512 In line 11, ora-00604ora-00942 The error is as follows:   I searched for many methods, but there was no solution, but finally I found a good

Oracle clears daily backup data and recovers tables accidentally deleted I. Clean up data tables for routine backup 1. Background: The system tablespace usage has exceeded 90%. As a result, a related junk data is cleared. 2. You need to clear the

ORA-01552: non-system tablespace & #39; xxxx & #39; do not use system rollback segments ORA-01552: non-system tablespace 'xxxx 'cannot use system rollback segmentsFault analysis:The UNDO tablespace data file is damaged, causing the update operation

Oracle transaction processing and instance demonstration jdbc operation batch DeletionTransactions As the basic unit of logical processing, database operations are composed of one or more SQL statements. Of course, there are also non-database

OracleHA high availability (II. In-depth analysis of TAF and HA Framework) Oracle HA high availability (one, client, server service details): http://write.blog.csdn.net/postedit We have seen that the Oracle session of TAF can be automatically

Create and delete Oracle users 1. Create a user: SQL> create user user01 identified by user01; User created. But the logon error 01045 is displayed, and the create session permission is missing. ERROR:ORA-01045: user USER01 lacks create session

OracleGoldenGate's thought sky-understanding the essence of OGG This article is an original article. For more information, see the source. Http://blog.csdn.net/msdnchina/article/details/38347285Oracle GoldenGate's thought sky-understanding the