Oracle

Most people, not all of whom are usually used in development, are 32-bit PCs. Therefore, oracle32-bit clients are installed. However, the general server is 64-bit and the 64-bit Oracle client is installed. to deploy the application that uses oracle.

Transferred from:Http://bbs.bccn.net/thread-310552-1-1.html The main problem is that the character encoding of the Oracle client is inconsistent with that of the server. Oracle Server character encoding: zhs16gbkOracle client character encoding:

  When looking at the example library, we found that some table DDL not only has the column part, but also has a lot of partition parts. I don't understand what it means. So I searched and found that it was a feature of oracle. The following are

Table Name and column naming rules 1. It must start with a letter2. The length cannot exceed 30 characters3. Oracle reserved words cannot be used4, can only use A-Z, A-Z, 0-9, $, # and so on Data Type Character Type:Char can query up to 2000

Original requirements: The OA system used SSH + extjs. When we tried it for the customer, the customer began to complain that the Chinese character data in the list was not properly sorted by pinyin, make changes to the customer. At first, I

One of the in-depth studies of Oracle's Materialized View (mview) One of the in-depth studies of Oracle's Materialized View (mview) Go to anysql.net A materialized view is provided from Oracle 8i to Improve the access speed of applications through

For tables with massive data volumes, index creation and query are much faster than those without indexes.Maintain data integrity Description: data integrity is used to ensure that database data complies with certain commercial and logical rules. In

Data Dictionary and dynamic performance View Data dictionary is the most important component of Oracle database. It provides some system information of the database.The dynamic performance view records information after the routine is started.I.

Create user Create User Username identified by password;   System Permissions Grant/Revoke create session to/from username; Grant/Revoke create table to/from username; Grant/Revoke unlimited tablespace to/from user name; Grant dBA, connect, resource

MySQLAdvantagesMySQL is a fast, multi-threaded, multi-user SQL database server. It is almost free of charge. It supports regular SQL query languages and multiple data types, and supports various detailed queries of data.MySQL's core program adopts

Very troublesomeRecord my tossing processFirst, PHP CompilationAfter setting Oracle environment variablesOracle_base =/opt/Oracle; export oracle_baseORACLE_HOME = $ oracle_base/product/10.2.0.1/db_1; export ORACLE_HOMEAddWith-oci8 Subsequent

There are two ways to modify the character set: 1) Export the original database, re-create a new database for the new character set, and then import the database. Note that you need to export and import the character set of the client. 2)Alter

    I 've been playing Oracle for almost two years. I 've been sorting out Oracle-related technical articles. I used to learn J2EE and went to training institutions for a year, at that time, I thought it was just about development, but it turns out

RMAN> startup nomount; RMAN> SQL 'alter session set nls_date_format = ''yyyy-mm-dd hh24: MI: s ''";-- Because RMAN reads the time format using environment variables by default, which is different from the fixed format of sqlplus, you must set the

 I. Problem Description Install RAC of Oracle 11.2.0.1 on vbox. An error is reported during SSH Configuration: INS-06006: passwordless sshconnectivity not set up between the following node (s)       Note: The strange result here is that setup is

   I. Test Environment SQL> select * from V $ version where rownum = 1;   Banner -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition release11.2.0.3.0-64bit Production   SQL> Create

   1. OS and DB versions Oracle version: 11.2.0.2 Operation System: HP-uxitanium 11.31    2. Alert Log Information   Tue Oct 22:27:31 2012 Exception [type: SIGSEGV, address not mapped to object] [ADDR: 0xc00000000] [PC: 0x400000000631b880, evaopn3 ()

  Oracle's ASM is a large piece of content, which has been sorted out separately. The link is as follows:   Oracle ASM details Http://blog.csdn.net/tianlesoftware/article/details/5314541   Summary of Oracle ASM

1. username and password after Oracle installation is completeSys/change_on_installSystem/ManagerScott/TigerSysman/oem_tempInternal/Oracle 2. Change the user's passwordSQL> conn sys/change_on_install as sysdbaConnected.SQL> alter user SYS identified

I. SCN description   I have also compiled several Oracle SCN articles as follows: An in-depth study on the relationship between the time modification problem and SCN of the Oracle DB Server System Http://blog.csdn.net/tianlesoftware/article/details/6