Oracle

1. Right-click the computer, select Properties, add environment variable Nls_lang:simplified Chinese_china. ZHS16GBK2. Go to the registry, click HKEY_LOCAL_MACHINE-->software-oracle-->key_oradb11g_home1, locate Nls_lang, set the value to: simplified

---restore content starts---Import Export (dos window) Database export:1 Export the database test fully exported to D:\daochu.dmpEXP username/password @orcl file=d:\daochu.dmp full=y2 Exporting the system user in the database to the SYS user's

Today the database except for a problem: a table in the project, the data is from the other system in the same table, but probably because of yesterday's colleague led the data in my table that the data appeared in the exact same situation (all

Oracle:CREATE TABLE Load(ID char ($) NOT NULL,Title VARCHAR2 (+) NOT NULL,Time VARCHAR2 (+) is not NULL,DEF1 varchar2 (100),Def2 VARCHAR2 (200),DEF3 VARCHAR2 (300),DEF4 VARCHAR2 (400),DEF5 VARCHAR2 (500),Dr Number (default 0),TS char (+) default

Oracle System usersSys,system, Sysman, Scott.Log on using System user[Username/password] [@server] [As Sysdba|sysoper]eg:system/123456 @orcl as SysdbaTo view the currently logged in User:Show userViewing users in a data dictionarySelect username

For a development, when the project is about to go online before the test phase, this process will often have some bugs, then we will generally be on the customer site to directly solve these problems. Then we may connect a lot of databases,

Today the system officially on the line, busy three months finally some harvest. Special trip to take photos, various opening ceremonies ... Last night, the bus to the station 5:30 this morning.Tried a few Oracle tools, the native SQL developer

XML version= "1.0" encoding= "UTF-8"?>Beansxmlns= "Http://www.springframework.org/schema/beans"Xmlns:xsi= "Http://www.w3.org/2001/XMLSchema-instance"XMLNS:AOP= "HTTP://WWW.SPRINGFRAMEWORK.ORG/SCHEMA/AOP"Xmlns:context= "Http://www.springframework.org/

With TMP as (Select ' 1 ' id, ' AA ' name, ' dual ' fromSelect ' 2 ' id, ' BB ' name, ' age from dual union ALL 'Select ' 3 ' ID, ' CC ' name, ' age from dual ')Select A.*, Lead (age,1) through (Order BY id desc) Lag, A.age-lead (age,1) over (

1. Open CMD,CD to the Oracle directory, such as D:\app\xty\product\11.2.0\dbhome_1\RDBMS\ADMIN2.sqlplus username/Password @ instance name, connect to database3. Execute @awrrpt. SQL carriage returnFirst step input type: HTMLEnter the number of days

--Create userCREATE USERJim identified byChangeit;--Assign login connection permissions to usersGRANTCONNECT toJim;--assigning resource permissions to usersGRANTRESOURCE toJim;--Reclaim Login PermissionsREVOKECONNECT fromJim;--Reclaim resource

This week just two systems on-line, a few days overtime to midnight, this weekend finally relaxed, can rest at home, fill a complement Oracle, or the previous tutorial, see "Update and transaction processing", look at the edge update it1, Insert:

Data Control Language Used to grant or reclaim access to various objects in the database, such as tables, views, indexes, etc.The basic operation is as follows:--Create userCREATE USERJim identified byChangeit;--Assign login connection

1:root User execution: Df-k/tmpFree space is greater than 400M can2:cat/etc/issue command to view Linux versions3:uname-r command to view the kernel4: Check the relevant packagesThe command is: RPM-Q related package5: Build two

"Oracel method for creating tablespaces"--Create a permanent table space--Create tablespace table space name (for example: Table_1)DataFile ' file path and filename (such as: F:\java\Oracle tablespace. dbf) ' Note: The suffix is BDFSize table space (

MySQL Data Type Oracle Data Type Java BIGINT Number (19, 0) Java.lang.Long BIT RAW Byte[] Blob BLOB, RAW Byte[] CHAR CHAR Java.lang.String

A view is a stored query definition.1. The syntax for creating a view is as follows:Create [OR REPLACE] [Force | Noforce] VIEW view_name[(Alias,alias,...)] Asselect_statement [with CHECK OPTION [CONSTRAINT CONSTRAINT]] [with READ only];Where: OR

Exp cjtxx/[email PROTECTED]/ORCL file=d:\cjtxx.dmp owner=cjtxx [tables=tablename]imp cjttest/[email PROTECTED]/ORCL File=d:\cjtxx.dmp full=y INSERT INTO bdf2_user_position (id_,position_id_,username_) VALUES (: New.username_, ' Ptjs ',: NEW.USERNAME_

1. View the existing table space and find the fallback tablespaceSELECT * from dba_tablespaces WHERE contents= ' UNDO '2. Create a new fallback tablespaceCreate undo tablespace undo_rbs1 DataFile ' E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS02.

Recovery of data deleted by mistakeOracle recovers deleted dataThere are two methods: SCN and time stamp two methods of recovery.I. Recovering deleted and committed data through the SCN1. Obtain the SCN number of the current databaseSelect