Oracle

(1) The concept of table space and partitioned tableTable Space:is a collection of one or more data files, all of which are stored in the specified table space, but are primarily tables, so called table spaces.Partition table:When the amount of data

To view the character set:SELECT * from V$nls_parameters;SELECT * from Nls_database_parameters;To modify a character set:Sqlplus "/as sysdba"Shutdown immediate;startup Mount;Alter session set Sql_trace=true;Alter system enable restricted

SELECT DBF. tablespace_name,      DBF. Totalspace "Total (M)",      DBF. Totalblocks as total block number,      DBF. Totalspace-dfs. FREESPACE "Usage (M)",      DBF. Totalblocks-dfs. Freeblocks as uses blocks,             dfs. FREESPACE "Total

#!/bin/Bash#Oracle Environment Variables Nls_lang=American_america. Al32utf8oracle_sid=Zgworacle_base=/opt/Oracleoracle_home=/opt/oracle/11gPATH= $PATH: $ORACLE _home/bin: $HOME/binexport oracle_sid oracle_base oracle_home nls_lang PATH#获取时间戳export

1. Source CodeString connstring = "User Id=scott; Password=yanhong;data source= (DESCRIPTION = (address_list= (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)) (C Onnect_data = (service_name = yanhong))) ";OracleConnection conn = new

--View of database nameSelect name from V$database;650) this.width=650; "Style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat Center;border : 1px solid RGB (221,221,221); "src="/e/u261/themes/default/images/spacer.gif "alt="

1.rownum:rownum is a pseudo-column that needs to be rownum when the data is taken out, so a nested query is required for paging lookups.SelectSal,ename from (SelectRowNum asRn,sal,ename from (SelectSal,ename fromEmpwhereSal is not NULL Order

--View of database nameSelect name from V$database;650) this.width=650; "src="%5c "alt=" spacer.gif\\ "\" "/>--View of instance nameShow parameter instance_name;650) this.width=650; "src="%5c "alt=" spacer.gif\\ "\" "/>--Data filesSelect name from V$

A set of SQL code for archive modesql> archive log list;#查看是不是归档方式Sql> alter system set LOG_ARCHIVE_START=TRUE Scope=spfile;#启用主动归档Sql> alter system set log_archive_dest= "Location=/oracle/ora9/oradata/arch" scope=spfile;#设置归档路径Sql> alter system set

1. Table field self-correlation and analysis function performance comparison, self-correlation needs to scan table two times, analysis function scan once can----Self-correlatingSelectV1.proj_id,v1.proj_start,v1.proj_end fromv v1,v

An example of using the sqlldr command to import data to an Oracle database table: sqlldroracleCSV: Comma-Separated Values (Comma-Separated Values) abbreviation. sqlldr is a multi-line text file with Comma-Separated fields. It is short for SQL *

Guess: the cause of SQLText & quot; ** SQLTextNotAvailable ** & quot; In the Oracleash report Guess: Why "** SQL Text Not Available **" appears in SQL Text in the Oracle ash report The HVR data synchronization software is being tested today. Due to

ORACLE-013: kill deadlock process in oracle In oracle, stored procedures or functions that frequently access packets may cause deadlocks. Scripts of deadlocked objects cannot be run, causing freezing or an exception: too many connections are opened.

ORA-12541: TNS: no listenersAfter I reinstall Oracle yesterday, ORA-12541: TNS: no listening program error occurs when I connect oracle with PL/SQL Developer, for example: With the help of Brother Wang Peng, I found that the oracle listener was not

Oracle physical storage structureOracle physical storage structure The database is actually composed of a pile of physical files, mainly including four:1. control files)2. Data files (Date files)3. redolog)1. Control File The control file is the

Create split and splitstr functions in Oracle It is recommended that SQL statements be created in sequence.   /*************************************** Name: split * author: sean zhang. * date: 2012-09-03. * function: returns the table type after a

How to install Oracle 11gr2 in OEL5.5, oel5.20.gr2 Virtual Machine environment: Vmware Workstation 11.1.0 + Oracle Enterprise Linux 5.5 X86-641. Physical Machine memory settingsMinimum: 1 GBRecommended: 2 GB or aboveMemory size:# Grep

Use of Oracletrunc () function -- Oracle trunc () function usage /************** Date TRUNC () the function does not have second precision *******************/select sysdate from dual -- select trunc (sysdate) from dualselect trunc (sysdate, 'dd')

ORA-28001: the password has expiredOracle prompt error message ORA-28001: the password has expiredCause: due to the new features of Oracle 11G, the default password expiration limit for Oracle 11G users is 180 days. If the user password is not

Oracle Study Notes (3) ----------- command Overview 1. ORACLE startup and Shutdown 1In a single-host environment To start or shut down the ORACLE system, you must first switch to the ORACLE user, as shown below:Su-oracleA. Start the ORACLE