Oracle

The following describes how to quickly implement the oracle test and installation environment: 1. Use the root user to mount the disc to the corresponding path, for example,/mnt (note that the default path is not needed ).Configure local yum

Oracle recovery accidentally deleted the table. Today, PLSQL accidentally clicked the drop action on a table, causing the table to be deleted. Www.2cto.com eventually uses the following command to restore: flashback table username. T_tableName to

Oracle Parallel uses oracle Parallel (Parallel) to use 1. query the SQL code SELECT/* + Parallel (t, 8) */* FROM emp t; SELECT/* + Parallel (8) */* FROM emp t; SELECT/* + Parallel */* FROM emp t; 2. SQL code for creating an index: create index

Oracle 11g remote Logon Setting (using plsqldev or sqlplus remote logon) using plsqldev or sqlplus remote logon to oracle configuration: these three configuration files are under your oracle installation directory: 1. sqlnet. ora configuration

Oracle truncate table Truncate is a SQL statement used to delete data TABLE content: syntax truncate table name parameter name is the name of the TABLE to be truncated or the name of the TABLE to delete all its rows. The following describes the

Rule 1 for Oracle 10g schema object names) except for the database link name, the schema object name can contain a maximum of 128 characters and a maximum of 30 characters. 2) reserved words (such as SELECT) cannot be used as object names. 3) All

Change redo log size (online redo log size) the Oracle online log and Oracle archive log record the complete change information of the entire database. Is an important part of Oracle architecture. Therefore, online log planning is also very

Oracle result set cache: oracle adjusts the result set cache with only three parameters. RESULT_CACHE_MAX_SIZE = 500 M/* Megabytes RESULT_CACHE_MAX_RESULT = 20/* Percentage limit = 3600/* Minutes, but all queries are saved only when

Three Data Guard Modes: Data Guard Protection mode (Data Guard Protection Modes) for Data Guard, its survival logic is very simple, because it provides three Data Protection Modes, we call it another kind: There are three models: Maximum protection:

Oracle modifies the path of the spfile file. Background: today, my colleague found that the oracle spfile file was used as a resource under + DG_DATA during the database dual-host switch, it was originally found in + DG_ORA that the spfile path was

Oracle operation statement Learning 1. oracle operation 1. connect to oracle: 1) sqlplus 2) scott 3) tiger] 2. sqlplus scott/tiger; 3. 4. sqlplus scott tiger 5. interface Logon: 5. exit quit Exit 2. query 1. select empno, ENAME, JOB, sal from emp

As far as I know, oracle versions 10 Gb later than oracle will not cause deadlocks due to user operation. This problem occurs when you log on to the system using the user name and password on the home page of your web project. You cannot access the

The SQL in statement can be joined up to 1000. By default, Oracle supports 1000 in the number of in statements. This is also for SQL Performance processing, because in statements do not have good performance. In this case, it is best to use

The grouping Function Definition of SQL grouping functions in Oracle databases is different from that of single-row functions. Grouping Functions Act on a group of records and each group returns a result. This group can be an entire table or a group

Common SQL statements for Oralce table operations [SQL] -- Create table create table table_name (id VARCHAR2 (50), create_time TIMESTAMP (6), column_name NUMBER )); -- alter table table_name modify column_name number (); -- Create table partition by

Oracle knowledge point summary (1) architecture: the database architecture refers to the composition, working process and principles of the database, and the organization and management mechanism of data in the database. The architecture includes:

Oracle listening service forced shutdown cannot start TNS identification Problem Solving Problem description: a while ago, when I went home while working on the project, I found that I could not connect to PLSQL. Then I found that tnslistener was

How to obtain the current system time in Oracle select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss') from dual; select to_char (sysdate, 'yyyy') from dual; -- select to_char (sysdate, 'mm') in ORACLE ') from dual; -- month select to_char (sysdate,

Use PL/SQL to connect to other Oracle databases1. Download the Instant ClientOracle official website address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlThe downloaded file is a compressed file. The

I was a newbie upgrading ORACLE databases from 10.2.0.1.0 to 10.2.0.2.0. Today I tried ORACLE database upgrades on a virtual machine twice, so I found that my initial thought was wrong! The original Database Upgrade requires two parts: 1. Upgrade