Oracle

Background: 64-bit operating system, no Oracle-32bit client installed, easy to use Plsql Developer (64bit-bit Oracle client not supported) 1, download Oracle Simple clients Instant Client: http://www.oracle.com/technetwork/topics/winsoft-085727.html.

When Oracle Database executes a SQL statement, it stores the result set and processing information in an unnamedprivate SQ L area. A pointer to the unnamed area, called acursor, lets youretrieve the rows of the result set one at a time.Cursor

This is a question that I have always been concerned about.11G about this problem has improved, to 12C more is a number of new featuresFor a discussion of the new features of 11G, refer to my blog http://blog.csdn.net/dbcrocodile/article/details/2117

Environment confessed: Linux 6.3Oracle Rac 11.2.0.4[[email protected] grid]#/u01/app/11.2.0/grid/root.shperforming root user operation for Oracle 11gThe following environment variables is set as:oracle_owner= grid

See an index today, create INDEX index_name tableanme (colname,0), very strange, never seen before. After testing the discovery is a thing relative to the joint index, there is no meaning, is built wrong.Sql> select * from V$version;BANNER-----------

Bbed can be modified in the DB open state, but it is recommended to shutdown DB before any modifications are made. This avoids the checkpoint process rewriting bbed's modifications to the block. Also avoid Oracle reading block or declaring block as

D:\Oracle\DevSuiteHome_1\j2ee\DevSuiteProblem Two: Problem two is on the basis of problem one, after the operation of the solution to the problem, run the form again, there will be browser crashes.Workaround:Step One: Locate the Jinit folder in the

PFILE and SPFILE 1, meaning:PFILE is the abbreviationof Parameterfile, SPFILE is the abbreviation of server parameter file, By the literal meaning of the full name, we can get pfile and SPFile are both Oracle supplied parameter files, which

Turn from http://www.cnblogs.com/yjhrem/articles/2340149.htmlRun the cmd command lineInput sqlplus/nolog no user name loginConn/as SYSDBA Connect to data Local dataAlter user system identified by password; Modify the system password to

Recently I have a project to import the original Oracle database data into MySQL, after trial found MySQL GUI tools MySQL Migration Toolkit can be very convenient to the Oracle data into MySQL, Especially for CLOB, blob type of data also have very

System platform: 64-bitMSSQL 2005 32-bitAfter installing the 32-bit Oracle client, create the Dblink times error in sql:The OLE DB provider "MSDAORA" for linked server "Szmesp" reported an error. The provider did not give any information about the

A Preparatory work1.1 Install the required RPM packageBinutils-2.20.51.0.2-5.11.el6 (x86_64)Glibc-2.12-1.7.el6 (x86_64)Libgcc-4.4.4-13.el6 (x86_64)Libstdc++-4.4.4-13.el6 (x86_64)Libaio-0.3.107-10.el6 (x86_64)libXext-1.1 (x86_64)libXtst-1.0.99.2 (x86_

Reprint Please specify source: http://blog.csdn.net/guoyjoe/article/details/41548669First, set1. Set BrokerSet each to true on the master repositorySql> alter system set dg_broker_start=true;2. Operate on the main library[Email protected] admin]$

oracle11g The default password expiration limit when creating a user is 180 days (that is, 6 months) and the user cannot log on if the user password has not been modified for more than 180 days. Oracle Corporation has introduced this default feature

Patch 10404530 [DIRECT download using Thunderbolt] 11.2.0.3.0 PATCH SET for ORACLE DATABASE SERVER for linux

System: CentOS64 + oracle11g x86_641. Close the firewall,# Vi/etc/selinux/configModify the selinux=disabled, and then restart.If you do not want to restart the system, use the command Setenforce 02, the establishment of script build.sh,# vim

Introduction to Autonomous TRANSACTION (Autonomous affairs)In the process of doing some projects based on the lower version of Oracle, sometimes there are some headaches, such as the need to record some information to the trace table for each step

Free and convenient Web application development framework for Oracle (1) APEX In general, APEX is the most convenient and efficient development framework I have ever seen. It is more comfortable to use than PHP. It was easy to get started, and the

How to encrypt rman backup sets in oracle Let's take a look at an oracle rman backup set encryption method. I hope this example will help you.   Data security is becoming more and more important. It doesn't mean that your production database is

Explore Oracle Database Upgrade 7 11gR2to12c after the upgrade is completed, insert PDB Explore Oracle Database Upgrade 7Insert PDB after 11gR2 to 12c upgrade is complete Preface:Since Oracle 12c, the concept of container database has been