Oracle

This article mainly describes how to deal with the problem of bad blocks in the Oracle database, for the bad blocks produced on different objects, the method of processing will be different, this article will be a general introduction to these

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

First, ASM (Automatic storage management) for the reason:ASM is a new feature introduced in Oracle 10g R2 to simplify the management of Oracle databases, a volume manager provided by Oracle itself, primarily used to replace the LVM provided by the

" This article declined to reprint Original from http://990487026.blog.51cto.com"Thought:1, set the Linux character set to UTF8 encoding2, set the Oracle character set to UTF8 encoding3, set the Sqlplus client environment to UTF8 encoding4. If you

Installation Environment:Redhat ES 5.5 64-bit, system memory 8g,swap 10G, Oracle 11G R2 Standard EditionOne, Oracle pre-installation PreparationCheck the package and you must install it all:binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc+

After the successful installation of the Oracle database will have a default user name and password, because there is no collation, each use of Baidu is very troublesome, so now put these all tidy up, also convenient for later use:Connect using the

Do indexes in an Oracle database need to be rebuilt on a regular basis? If you do not need to rebuild regularly, what is the reason? If you need to rebuild regularly, what are the reasons? Also, if you need to rebuild regularly, the indexes that

As the complexity of the system increases, the distributed systems we face are growing. Distributed file system, distributed Message Queuing system, and so on, in some industries, especially the Internet industry widely used. DistributedDatabaseIt

CREATE Database Link Test_dblinkCONNECT to SJZX identified by SJZXUSING ' (DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.176.150.201) (PORT = 1521)))(Connect_data =(service_name = ORCL)))‘;Database Link OverviewDatabase link is

Recently began to learn Oracle database, according to my understanding of Oracle database is a powerful, complex, high-performance database, and expensive, the use of large enterprises, local tyrants dedicated. Learning a database to get started is

"How to update with views"There is a need for a table, B table, the Name field in table B is updated to the name in table A, two tables have ID associated with the code as follows:Update (select A.name aname, B.name bname from a, b b where a.id =

Oracle user creation and permission settings [reprint]Permissions:Create sessionCREATE tableUnlimited tablespaceConnectResourceDbaCases:#sqlplus/nologSql> Conn/as sysdba;Sql>create user username identified by passwordSql> Grant DBA to username;Sql>

To create a function:Create or Replace function My_fun (in_no in number) return VARCHAR2 isOut_name VARCHAR2 (64);BeginSelect Ename to Out_name from EMP where emp.empno=in_no;return out_name;End My_fun;Java Program Demo:Import

Method One: Enter the connection information directly in the connection poolThe string followed by the connection information configured in the Tnsname.ora is stripped of the space and line breaks. (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 1

The type initializer for "Oracle.DataAccess.Client.OracleConnection" throws an exception.Was plagued by this problem for a long time, and finally found the reason :The original version of the Oracle client that was natively installed is inconsistent

Have always wanted to learn Oracle, but is the installation of Oracle has not been successful, people are very distressed, especially what listener what, has not understood, got a whole day did not get out, the Internet to find information on most

Oracle performance optimization and oracle database performance optimization (1)Select the most efficient table name sequence (valid only in the rule-based Optimizer ):The ORACLE parser processes the table names in the FROM clause in the order FROM

ADDM Reports bug: Significant virtual memory paging was detected on the host operating system, addmpaging When you view the ADDM report (the database version is ORACLE 10.2.0.5.0), it is very unreliable: Significant virtual memory paging was

Oracle uses JDBC to add, delete, modify, and check whether the table exists. oraclejdbcOracle uses JDBC for addition, deletion, modification, and query Databases and tablesTable USERS ( USERNAME VARCHAR2 (20) not null, PASSWORD VARCHAR2 (20) ) Alter

[Switch] oracle Regular Expression and oracle Regular Expression1. Brief Introduction to oracle (regular expression) At present, regular expressions have been widely used in many software applications, including * nix (Linux, Unix, etc.), HP and