Oracle

Table join refers to the association between tables in an SQL statement to retrieve relevant data from one or more tables. The join operation is performed by multiple table names of the FROM clause in the SQL statement and the join conditions

  Oracle correctly deletes the archivelog File After the archive mode is enabled, Oracle will generate many archivelog files under the specified archive Directory, which is not cleared regularly by default and takes a long time, this folder occupies

In the past few years, we have made data recovery orders and often encountered Oracle cases. When we recover data, how can we let users see what is in the oracle database, instead of one oracle data file, the following is my summary, which is useful

Sometimes, DBLink is one of the most convenient and convenient ways to manually synchronize data between two Oracle databases. The DBLink creation method is generally as follows: SQL codeCreate public database link connect to identified by using '

When the client uses pl/SQL dev to connect to the database, a prompt (dedicated server mode) is displayed during login ).ERROR:ORA-12516: TNS: listener cocould not find available handlerMatching protocolStackWhen modifying the parameters, it is

NUMBER Type Details:Oracle number datatype Syntax: NUMBER [(precision [, scale])]Short for: precision --> pScale --> s NUMBER (p, s)Range: 1 Data storage range:-1.0e-130 Saved in the machine range: 1 ~ 22 bytes Valid: the number of digits from the

Modify the SPFILE ValueLog on to the Oracle server and use related commands to modify the corresponding values.Alter system set parameter = value Sid = 'sid | *'The default value is *, indicating all instances. Generally, the next Instance

Connect:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show parameter sec_case_sensitive_logonNAME TYPE VALUE--------------------------------------

1. What is the oracle character set?The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. ORACLE supports the national language

When a Java program connects to the oracle database, the oci driver has better performance than the thin driver. The main difference is that the oracle client does not need to be installed when the thin driver is used, but the oracle client must be

Manual configuration of Oracle 10G Enterprise ManagerThe following error is reported when oracle is installed several times;Enterprise Manager Configuration failed due to the following errorAn error occurred while starting Database Control.For more

Back up the database today, after shutdown immediate shut down the data, startup mount opened the database, ora-03113: Database channel appears eof.The database version I managed is 9.2.0.6, the operating system is windows server 2003, the server is

Oracle log modes include archivelog (enable archive log) and noarchivelog.View the Database Log mode:Select log_mode from v $ database;   Log_mode-----------------------------------Archivelog How to enable Oracle Archiving:1. Edit the init. ora file

PMON failed to acquirelatch, see PMON dump these two days suddenly found a set of running Oracle 10.2.0.1 for RHEL 5.8x86 _ x64 database shut down very slowly, up to 4 minutes, shutdown immediate after alert. log reports a large number of "PMON

The difference between rowid and rownum for the rownum problem in Oracle is not supported by many materials>, >=, =,... and, can only use the above symbols (,> =, =, .. and will prompt SQL syntax errors, but often cannot find a record, and it seems

Steps for converting physical standby to logical standby 1. slave database: after synchronization with the master database, stop the log application alter database recover managed standby database cancel; 2. master database: build data dictionary

[Oracle]-[AWR/Stackpack]-AWR (Stackpack) Execution permission: Oracle 9i executes Stackpack (10 Gb is AWR). It is a common account and has no DBA permission. SQL> @awrrpt.sqlCurrent Instance~~~~~~~~~~~~~~~~ v$instance i *ERROR at line

Spfile and user environment variables and export RAC database environment variable settings [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 31 12:45:01 2012 Copyright (c) 1982, 2005, Oracle. All rights

To Kill the session, turn off sqlplus. An error occurred while compiling a function today. I can't finish running it all the time. keep running and keep running. after kill the session, we can see that mark killed sqlplus is not switched off in the

Oracle Data Pump usage (1) Oracle Data Pump expdpimpdp I. Data Pump export steps: 1. Create a directory (I created it using a system user, scott user does not have permission) create directory dump1 as 'e:\dump' ;  2. Authorize scott user grant read,