Oracle

Using Rman to implement incremental database recovery based on SCN is a common method of repairing gap in DG. In fact, this method can also use the conventional incremental recovery, through manual control, to achieve a certain specific business

Operating system: Red Hat Enterprise Linux Server Release 6.2 x86_64Oracle version: Oracle Database 11g Release 2 Oracle Official Download Address:File1:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_1of2.zipFile2:http://

The Oracle tutorial you are looking at is the security policy for Oracle databases. ----Oracle is a relational database management system, which has powerful function and excellent performance, and occupies an important position in today's large

Article Source: Database Forum Author: Jackma The Java Database Connectivity (JDBC) API is a series of interfaces that enable Java programmers to access the database, and the interfaces of each developer are not exactly the same. After years of

Open SQL Server can only run on Windows, without the slightest openness, and the stability of the operating system is important to the database. Windows9x Series products are focused on desktop applications, NT server only for small and medium

Data files for Oracle databases (files with the extension DBF) are files that are used to hold the data in the database, and system data, data dictionary data, temporary data, index data, application data, etc. are physically stored in the data file.

The basic Concept Character set (Character set): is a collection of all abstract characters supported by a system. Characters are the general name of various words and symbols, including the national characters, punctuation marks, graphic

One. Query article 1. Query Oracle Table space usage Select b.file_id file ID, B.tablespace_name table Space, B.file_name Physical file name, The total number of bytes b.bytes, (B.bytes-sum (NVL (a.bytes,0))) has been used, Sum (NVL (a.bytes,0))

Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix

Oracle decode functions are very powerful, and here's a detailed description of the use of the Oracle decode function, hopefully giving you a better understanding of Oracle decode functions. Oracle decode functionsThe Oracle decode function is an

Before using compression, we can estimate how much the effect of using compression can be. 11GR2 can use dbms_comp_advisor before, the specific code has been given in the attachment. You only need to execute two files Dbmscomp.sql and PRVTCOMP.PLB,

This paper introduces the comparison of DB2 common functions with Oracle in detail 1. Type conversion functions: Decimal, Double, Integer, Smallint,real,hex (ARG), Date, Time,timestamp,char, varchar Common examples: --Convert to String type

Query initialization parameters A lot of ways, such as show PARAMETER, or query V$parameter, here a brief summary. This article describes the necessity of gv$spparameter parameters. The previous article describes the V$spparameter parameter and

I. DBlink Brief Introduction 　 dblink Database link as the name implies is a database link , like a telephone line, is a channel, when we want to cross the local database, access to another database table data, the local database must be created in

Sharing a form to generate Excel file for SQL query in Oracle Forms.   This form can is used in Oracle Forms 6i and 10g/11g. Below is the shot of this form and could was download from the following LINK:EXCEL_REP.FMB A procedure Create_ Excel_file

Software versionOracle Enterprise Linux 7.1 64bitOracle Enterprise Edition 12.1.0.2 64bitZabbix 3.2.1Ready to work upload softwareWe choose Zabbix 3.2.1Decompression path is/u01/stage/zabbix-3.2.1Prepare the required software to install Oracle 12.1.0

Download the 3 required packages (in order to connect the 11g database)1:oracle Client (Oracle clients)Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.htmlDownload Win64_11gr2_client.zip

Count Detailed:   COUNT (*) returns the total number of rows that exist in the table, including rows with a value of null, whereas count (column name) returns the total number of all rows except null in the table (columns with default values will

Course ObjectivesOracle Video tutorial, wind Brother this set of Oracle Tutorials Training Learning bbed, data blocks, including in-depth analysis of Oracle data storage architecture, tablespaces (tablespace), segments (segments), zones (Extent),

In general, if we perform the alter operation, the drop operation is not triggered. However, in some special cases, the alter package operation can see the drop operation in recursive SQL.We have a trigger in this environment, once there is a drop