Oracle

(Note: This digest is from http://www.linuxidc.com/Linux/2012-04/59322.htm)Start learning Oracle, so we're going to install Oracle 10g today. After the installation is done to test whether the normal work.During the installation process, the

1, create a temporary table space when creating a tablespace, the DBF file is generally stored in the datafile file directory (usually under the name of the instance folder) can be through the select * from V$datafile; View all data file storage

When we create a table, Oracle creates a segment for us, that is, the table is equivalent to a segment, the first time you create a table, allocate a zone for us to use, the area is generally 8k size, each zone has 8 blocks, when the data is stored,

"This article describes"This article describes how to use the graphical tools Navicat for Oracle to connect to the local database and the remote access server database.【】Http://www.navicat.com.cn/download/navicat-for-oracle"11G version access to

Table Space :Oracle allows different types of data to be stored separately, and Tablespace is a logical division of the database.Data Files :A tablespace consists of one or more files on the same disk, which are called data files.Example :is the

Oracle MinuskeywordMinuskeyword in SQLThere is a minuskeyword in SQL that uses two SQL statements to find out the results of the first SQL statement, and then see if the results are in the results of the second SQL statement. If there is, then this

Vi/home/oracle/.bashrcUmask 022Oracle_base=/usr/lib/oracleOracle_home= $ORACLE _base/11.2/client64Path= $ORACLE _home/bin: $PATHLd_library_path= $ORACLE _home/libTns_admin=/usr/lib/oracle/11.2/client/network/adminExport ld_library_path oracle_base

1, first find out which table of the table space is not correctSELECT * from Dba_tables where tablespace_name= ' TDB ';2. Move table space in TDB to table space TDB2009The syntax is: ALTER TABLE table_name move tablespace tablespace_name;alter table

DML statement Flow1 Get transaction Lock and ITL2 Locking candidate rows3 Generating Redo4 Generate Undo5 Generate redo record write to log buffer and change data blockTransaction commit1 assigning SCN2 Update the Transaction table to change the

Usually to build a large number of Oracle test environment, repeat more and feel the trouble, simply the entire script to create a number of environment variables before the installation of Oracle and other related configuration, improve the

1, the official download installation package: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlLinuxamd64_12102_database_1of2.zipLinuxamd64_12102_database_1of2.zip 2, creating oracle Users and Groups  [Email

On many occasions, we will need to use Oracle column merging, and Oracle provides methods for merging multiple rows of data from a column into a single row.First, 10G before using Wmsys.wm_concatWmsys.wm_concat separates the values of the fields

Basic commandsSqlplus/as sysdba--Command line open Oracle (logged in as DBA)Drop User myusers cascade;--delete users (Cascade)Create user myusers identified by 123;--creating users (user name: Myusers. Password: 123)Grant Connect,resource to myusers;

Oracle scott unlock steps, oraclescott Run cmd Sqlplus/nolog press ENTER SQL> conn/as sysdba press ENTER SQL> alter user scott account unlock; press ENTER SQL> disconnect press ENTER SQL> conn scott/tiger @ orcl; press ENTER Enter two new passwords

Oracle 11gR2 real-time client configuration (Windows) 1. Download the real-time client that suits your system first. You can download the client from the address below. Http://www.oracle.com/technetwork/database/features/instant-client/index-097480

Oracle 11g warning log and listening log deletion method, oracle11g The listening and warning logs for oracle 11G are in the/u01/oracle/diag/tnslsnr/oracle/listener directory and/u01/oracle/diag/rdbms/db1/db1 directory. the listener directory and db1

Oracle Database Password Reset, Import and Export command example application, oracle Import and Export The reset method is as follows: Open the CMD command prompt and enter the following command to reset: Enter sqlplus/nolog, and press ENTER SQL>

Oracle Optimization-double-edged sword Oracle optimization is a double-edged sword. Pay special attention to the use of this sword:OLTP or OLAP Optimization 1: Index During DML operations, indexes must be maintained. If a large number of DML

OracleGoldenGate (ogg) 11.2.1.0.20 is the last ogg version that supports oracledb10g. Reference Original: Oracle GoldenGate 11.2.1.0.22 Patch Set Availability (Doc ID 1669160.1) This article does not translate and only extracts valuable

Oracleimpexp command details How to import dmp database files in oracle? Importing and exporting oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local