Oracle

The new Windows 7 system requires an oracle database. The installation method is slightly different.1. Download and install Media "for Oracle Database 10g 2nd version 10.2.0.3 of Microsoft Windows Vista". If the installation media is too large,

The solution for Oracle TNSListener to automatically stop when it is started has been normal. Today, we suddenly find that the TNSListener service cannot be started. After starting it on the service console, refresh it, it automatically returns to

Method 1: directly modifying the resource configuration file is completed in the sqlplus environment in three steps. Step 1: query the resource file and find the profile name of CONNECT_TIME. Select resource_name, profile from dba_profiles; Step 2,

1. Set the value of the NLS_SORT parameter SCHINESE_RADICAL_M to sort SCHINESE_STROKE_M By the beginning (First Order), strokes (Second Order), and heads (Second Order) sort SCHINESE_PINYIN_M by pinyin: www.2cto.com 2. set the Session level. Modify

Creating -- create a stored procedure to call explain create or replace procedure PLAN_AUTO_FACTTIME_PROC (time_plan_lastDay in varchar2, fact_cost_am in number, fact_cost_pm in number) is I number; previous_day varchar2 (50); begin www.2cto.com I: =

The ALL _ view returns information about ALL objects that a user can access without considering its owner. For example, a query of ALL_TABLES not only returns a list of all user-owned Relational Tables, but also returns a list Of all Relational

1, first go to the Oracle site to download Instant Client: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.htmlDownload a compressed file from different Instant Client versions based on your operating system. The

Oracle Auto-growth sequence Implementation about auto-growth sequence, I went back yesterday and tried to implement the Code item table-- Create table Code_Main (CodeID number primary key, CodeName VARCHAR2 (50); -- create sequence www.2cto.com

View oracle tablespace usage 1 select 2 B. file_id File ID, 3 B. tablespace_name tablespace name, 4 B. bytes/1024/1024 | 'mb' number of bytes, 5 (B. bytes-sum (nvl (. bytes, 0)/1024/1024 | 'mb' used, 6 sum (nvl (. bytes, 0)/1024/1024 | 'mb'

Oracle archive log (ARCH/ARCn) process overview in Oracle optional background processes, the most important is the archiving log process.If data files in the Oracle database are lost or damaged, full recovery should be performed in archive mode. In

ORACLE is a simple and practical SQL statement that converts rows and columns of data and collects statistics. Suppose there is a "beauty" table in the database, you need to use the values in cells in the column "signs" as the new column and column "

Test oracle 11g fixed execution plan-Baseline1. Select SQL _id [html] SQL> pagesize 300 SQL> set linesize 300 SQL> set autotrace on SQL> var name varchar2 (10); SQL> exec: name: = 'it'; select department_name from hr. orders ments dept where

For example, if you want to query records with identical names, ID card numbers, and addresses in a personnel table (table name: peosons), select p1. * from persons p1, persons p2 where p1.id <> p2.id and p1.cardid = p2.cardid and p1.pname =

When you execute a query for a very long time, may encounter a ora-01555 error, this article to simulate and explain the reason. 013555 because the queried data is modified during query execution and cannot be found in the undo tablespace. first,

Symptom:In the development process, numbers and strings are often required to convert each other. In the conversion process, you may need to program 1 to 00001. There are many ways to achieve this. This article mainly provides a user-defined

Oracle recovery scenario 1-simulate that data files are damaged or lost. In this scenario, data recovery is relatively simple, but it is still necessary to record work logs. DB version: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit

The most basic task of a database is to store and manage data. The only database that an end user can see is its performance: the speed at which the database processes the results of a specified query and returns the results to the tools and

Analysis of small table cache to memory the db_buffer_pool of oracle consists of three parts:Buffer_pool_defualtbuffer_pool_keepbuffer_pool_recycleIf you want to pin the table to the memory, that is, pin the table to the keep area. -- If the table

Oracle client PLSQL connection failure solution I wrote in my blog last week that the oracle client is connected to the server http://www.bkjia.com/database/201206/137699.html This article solves the troubles of installing on your own book. Www.2cto.

Oracle tablespace functions compared with other databases, the primary feature of Oracle data is the introduction of tablespaces. This article describes the Oracle tablespace. Oracle Database pioneered the design concept of tablespace, which makes