Oracle

HelloBeijing Shennao invites you to attend a webinar using WebEx.650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/3F/0D/wKiom1PIhfejSXSKAAIUA-fWiBg920.jpg "title=" 14053072882561.jpg "alt=" Wkiom1pihfejsxskaaiua-fwibg920.jpg "/>Topic: Web

Oracle 10g and later versions have a new feature that automatically adjusts the undo retention time, which is much simpler to manage, for auto-scaling (Autoextend on) undo tablespace, Parameters Undo_ The retention is set as the lowest threshold for

This article is original article, reproduced please indicate the sourceOracle Goldengate's thought sky--feeling the essence of OggThe title of this article, the high imitation of the white total "dba of the Mind of the sky-the understanding of

"This article describes"The previous several said so much, finally did not talk about how to connect to the database with Java, this article is practical, talk about how to connect the database."Java Connection to Oracle database" 1 . Import the

The Replace function uses the following:Replace (' string to be changed ', ' replaced string ', ' replace string ')The Chr () function in OracleCHR ()--converts ASCII code to charactersGrammarCHR (Number_code)ExampleSelect CHR from dual; --return '

Additional DB patches are required for use with Schematrandata in Ogg (Oracle GoldenGate)Reference text:Patches needed to support Schematrandata in OGG (Oracle GoldenGate) (Doc ID 1426440.1)Suitable for:Oracle goldengate-version 11.1.1.1.1 and

CreateOrReplacefunction F01_sx03_sum (statdateVarchar2, codeVarchar2, paraVarchar2)RETURNNumberIsV_meNumber; V_mbNumber;BeginIf para=‘Me‘ThenSelect NVL (Sum (NVL (Me),0)),0)/10000IntoV_meFromSx03_gl_accass Twhere T.ccodeLike (code||‘%‘)and T.iyeriod=

Oracle's official documentation-related notes: For your reference only, welcome to correct, make suggestions oh 650) this.width=650; "src=" Http://img.baidu.com/hi/jx2/j_0002.gif "alt=" j_ 0002.gif "/>Steps:Click on the Master book List in the top

Oracle 11gR2 Database Flashback-- preventing human logic errors1.Flashback What is the role of the DJI ERP system?for some human-made errors, such as bulk deletion of data, we can recover through the flashback function. The disadvantage is that the

Configuration: Source database 100.100.100.21 instance name Dbsid2 Target Database 100.100.100.41 instance name db1Experimental target: The Scott user emp table in the source database is synchronized to the test table in the target database

SQL statement for querying and deleting duplicate records 1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to determineSELECT * from Peoplewhere Peopleid in (select Peopleid from People GROUP by

11g Oracle Export table will default to no export data is empty1, oracle11g default to Empty table is not assigned segment, so use EXP export oracle11g database, empty table is not exported.2. After setting the Deferred_segment_creation parameter to

Sqlplus has several landing methods such as: 1. C: > Sqlplus "/as sysdba" C: > Sqlplus/as sysdba --Oracle SYS administrator logged in 2 with operating system Authority authentication. C: > Sqlplus/nolog --not in CMD or terminal

Get table field:SELECT *From User_tab_columnswhere table_name= ' user table 'ORDER BY column_nameGet Table Comments:SELECT *From User_tab_commentswhere table_name= ' user table 'ORDER BY table_nameGet field Comments:SELECT *From

Oracle session connection number and inactive issue recordhttp://timnity.javaeye.com/blog/280383Since last week, the server Oracle database problems, in less than half a day, will be reported maxsession (150) problem, it is certain that the database

1.Change.. Refhost.xml file under/db/disk1/stage/prereq/db, added before 2.Change.. /db/disk1/install the Oraparam.ini file, add the following (the red part is the added part):[Certified Versions]#You can customise error message shown for failure,

Learn to use an OEM todayThe result is two questions!The first question: Where should I open an OEM?Solution: Find a half-day, only to know that only using IE can open the OEM,The URL used is:https://localhost:1158/em/OK, when you open this URL, you

An example of random acquisition of any row of data (rownum) in the oracle database: oraclerownum Recently, when reading oracle data, I learned the concept of rownum. I used to only know how to add, delete, modify, and query database tables; After

ORACLE uses WITHAS and HINTMATERIALIZE to optimize SQL statements to reduce FILTER efficiency During project creation, a page uses SQL statements similar to the following to query data, I replaced the table name and field in the project with the

GoldenGate process abend, error: OGG-00868ORA-02396: ExceededMaximumIdleTime, PleaseConnectAgain GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again Reference Original:GoldenGate Processes Abend