Oracle

There are many ORA-600 4000 errors encountered during the recovery of the database, but in Oracle 8i (8.1.7) This is the first time to make a memory for reference:Database failure causes: The current redo is corrupted because of a storage exception,

SQL Server and Oracle acquisition time and date difference1. Get System Current TimeSQL Server 2005: Select GETDATE () The GETDATE () function returns the current time and date from SQL Server. GrammarGETDATE () instanceExample 1Use the following

SQL string connection function (MSSQL MySQL tutorial Oracle)MySQL String connection concat functionHow to use:Concat (STR1,STR2,...) MySQL appends a string to a field in the table:UPDATE table_name set FIELD=CONCAT (field, ', str ') MySQL adds a

Today to learn Oracle, and then think about the next, the results have a lot of problems, here to share, crazy, too painful, learning the tutorial is Oracle 11g, I went to the official website to download the Oracle 12g, the file is very large,

http://blog.csdn.net/baidu_24256693/article/details/44863935Because both Tomcat and Oracle are installed on the computer, 8080 of the ports are conflicting.There are many articles on the web that introduce the modification of the Tomcat port,

First, hardware requirements1. Memory and Sweap: Memory 2G (above), Sweap 2G (above)Memory: 1-2g 2-16g 16G or moresweap:1.5 Memory 1 time times memory 16GCheck: # grep Memtotal/proc/meminfo# grep Swaptotal/proc/meminfo2. Disk: 20G or moreCheck:

15511477451 Original Oracle 11g The listener does not start during installation or the database service is not registered to the listener? Environment: Win7 64-bit system, oracle11g databaseProblem Description: Install oracle11g under the Win7

This article from: http://www.cnblogs.com/yangxia-test/p/3922775.htmlA. DownloadHttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html the following two Web site source this official download page Web.Win 32-bit operating

Experience Summary:The online log is divided into the current online log and non-current online logs, the damage of non-current online logs is relatively simple, generally through the clear command to solve the problem.Corruption of non-current

I. Oracle database structure1. Logical Structure1.1. Data Block (Orale block): A certain number of bytes of disk space in the operating system's storage system. The data block is the smallest logical part of the Oracle database. can be defined as 2K,

Environment Introduction:OS: both [[email protected] ~]# uname-aLinux java3 2.6.18-308.el5 #1 SMP Tue 20:06:06 EST. x86_64 x86_64 x86_64 Gnu/linuxMain Library: Database version: 11.2.0.3.0 Two nodes of RAC node one: 192.168.15.26 node Two: 192.168.15

One, Oracle 11g installationBefore installing to determine your own computer configuration, Windows as an example, if it is Win7 the following systems such as XP, you can select Oracle 10g. Because the program file of 10g only more than 200 trillion,

Windows server2008/2012 installation Oracle 11.2.0.1 When you create a DB instance, you may be stuck in the 2 the place. this time can　　1 , click the Start menu, and in search programs and files, enter msconfig ", enter to open the System

An example was given below to what to create a modal dialog windows in Oracle Forms for asking user input and return the Valu E to any text item.   The following is the screen shot of this demo and this form could are downloaded from the following

Oracle database is still at the forefront of commercial databases. The security of the core business and core data running on the Oracle database is particularly important.There are generally two broad categories of disaster recovery products that

Oracle's schema, schema, model, and user references are as follows:Http://blog.sina.com.cn/s/blog_61ebea690101756n.htmlHttp://www.tuicool.com/articles/IzAZbiUHttp://blog.sina.com.cn/s/blog_6fda3085010133f4.htmlHttp://www.2cto.com/database/201205/1312

The advantages of this method: 1, the integration of Oracle client within the program, no need to configure users themselvesThe disadvantage of this method: 2, increase the volume of the package (Oracle Instant client itself has a few 10 megabytes

Oracle 12C user creation vs. table space allocationAfter the database installation is complete, the table space ' IMEI ' in the Database Container (CDB) is first created with the System User link Database Container (CDB)

Racle Basic data types (also called built-in data types built-in datatypes) can be categorized by type: String type, Number type, date type, LOB type, LONG raw& RAW type, ROWID & urowid type.A String typeChar type char (size [BYTE | CHAR])Char type,

How ORACLE produces a random number: Dbms_random--1, Decimals (0 ~ 1)Select Dbms_random.value from dual;--2, decimals within the specified range (0 ~ 100)Select Dbms_random.value (0,100) from dual;--3, integer within the specified range (0 ~