Oracle

http://welcomyou.javaeye.com/blog/371189 Ja16sjistilde Japanese_japan. Ja16sjistilde Oracle Nls_lang Summary Keyword: Oracle Nls_lang character Set character set to get a database from the customer, the client's database server is Ja16sjis, and

http://junmail.javaeye.com/blog/137996 1. Nls_lang parameter compositionThe Nls_lang parameter consists of the following sections:Nls_lang=_. The meaning of each part of the Nls_lang is as follows:Language specify:Language used by-oracle

Installing Oracle on RHEL requires some necessary packages, such as binutils compat-db compat-libstdc++-33 control-center gcc gcc-c++ glibc, and so on. If one of the outfit, really very troublesome, fortunately with Yum and oracle-validated: 1

IMPDP smtj2012/password @localhost/devdb directory=dump_dir dumpfile=bkmmtdb_smtj20130417120001.dmp REMAP_SCHEMA=SMTJ: smtj2012 remap_tablespace=smtj:smtj2012 Data Pump IMPDP Parameters:1.remap_datafile This option is used to convert the source

Create or Replace procedure Tj_data is--variable v_tablename VARCHAR2 for the current stored procedure ; V_sql varchar2 (); V_count integer; --Gets all the tables in the current database CURSOR Table_loop is SELECT table_name from

Oracle's optimizer has two optimizations, namely, rule-based optimization (rule-based optimization, short rbo) and cost based optimization (cost-based optimization, referred to as CBO), In Oracle8 and later versions, the Oracle Strong column

Four ways to start Oracle databases 1, Startup Nomount Non-installation startup: This way to launch executable: Rebuild the control file, rebuild the database, start the instance, that is, start the SGA and background processes, this startup

To create a process script for a package declaration: CREATE OR REPLACE PACKAGE "Com_bos" is-------------------------------------------------------------------------Description: --Constructing SQL statements of type B

See an article on the online Oracle cold backup, very detailed: First, cold backup The process by which the database completes copies of all physical system files in the shutdown state, also known as offline backup Suitable for non-archive mode,

Guide: 　　 First, the introduction: A rollback segment is a part of a database that records information about changes to the database. Use this information to implement the read consistency of the database and its recovery. If the rollback segment

1. System Rights Management1.1 3 Default UsersOracle 9iSYS Change_on_install [as Sysdba]--sqlplus/as sysdbaSystem ManagerScott TrigerOracle 10g aboveSYS Setup when it is installed. [As SYSDBA]Setup when system is installed.Scott Triger is locked by

Oracle 10g is installed under Win2008, prompt program terminates abnormally, unknown error occurred Modify Oracle 10g\database\stage\prereq\db\refhost.xml In Add later and find the Oraparam.ini file in the install directory to find Right-click

Create or Replace function test111 (ItemNumber in varchar2) return sys_refcursor is return_cursor sys_refcursor; begin OPEN return_cursor for SELECT ' a ' dual WHERE 1 = itemnumber; return return_cursor; End test111; Use the following

1. View Oracle Max Connection numberSql>show parameter Processes #最大连接数2. Modify the maximum number of connectionsSql>alter system set Processes=value Scope=spfileRestart the databaseSql>shutdown ForceSql>start Force3. View the current number of

There are several reasons for ORA-01034 and ORA-27101 errors: 1. The main Oracle current service is not available, shared memory realm does not exist, because Oracle is not started or does not start properly, share memory is not assigned to the

in development, we may have deadlocks when manipulating the database, and if we don't want to wait, this requires us to manually kill the process. Oracle View Lock Table SELECT l.session_id Sid, S.serial#,

  Software Environment Windows oracle9i  + hardware environment CPU 1.8G + RAM 512M   Now we have 2 tables   as follows: t1--large table 10000 strokes  t1_fk_id T 2--Small Table 5000    t2_pk_id T1 by the field ID in the table and T2 the primary key

Log in to the database with DBA authority. 1, select * from V$locked_object detect the Locked object, where object_id is the object of the id,session_id is locked object has a session ID; 2, select object_name, object_ Type from dba_objects where

1. Log in with SYS user Sqlplus Sys/pass@tt as Sysdba 2. Look at the location of Archiv log Sql> Show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ Log_archive_dest

Several ways in which a function/procedure in Oracle Returns a result set: In the case of function return, the stored procedure can only be changed to out parameters and passed in the Oracle 10g test. (1) Return cursor: The return type is: