Oracle

OCR corresponds to the registry of Windows. For Windows, all software information, users, configuration, security, and so on are all in the registry. And the cluster, again, all cluster-related resources, configurations, nodes, and RAC databases are

Description This article installs the Oracle 11g Dataguard physical repository and tests the 11g Dataguard physical Repository's new feature active Data Guard, which is a function of Oracle Database Enterprise Edition, which requires the amount

1 Running Sqlplus Tools Sqlplus 2 The default identity of the OS Connection /As Sysdba 3 displaying the current user name Show user 4 go directly to the Sqlplus command prompt Sqlplus/nolog 5 connecting at the command prompt with OS

The Oracle tutorial you are looking at is the implementation of a dynamic Web database for Oracle components. [Abstract] This article briefly introduces the basic methods of implementing a Web database, discusses the basic method of implementing a

1. Create a stored procedure Create or Replace procedure test (var_name_1 in type,var_name_2 out type) as--Declaring variables (variable name variable type)Begin--The execution body of the stored procedureEnd test;Print out the time information

Today, when you import a batch of data to Oracle, you have this problem: Toad prompted to assign to a custom variable amp, at first I was puzzled that the data is a series of INSERT statements, how can there be a custom variable? Then I searched the

One, what is the implementation plan (explain plans) Execution plan: A description of the execution process or access path of a query statement in Oracle. Ii. How to view the execution plan1: Under Pl/sql press F5 to view the execution plan.

The Creates a function in Oracle that was intended to return a index table without success. Think of the text can also transfer information, suddenly came to the inspiration, the return value set text format. The return value type is set to CLOB,

First, Oracle download Note that Oracle is divided into two files, after downloading, two files are extracted into the same directory. In the path name, it is best not to appear in Chinese, and do not appear irregular characters such as

Personal experiments sometimes use large tables, where you can share the dba_objects to create a test large table: First set up the test table Sys@orcl>create table Test nologging as Select RowNum id,a.* from Dba_objects a where 1=2;

First, the concept of the user Users, or user, is a popular way to access Oracle database "people." In Oracle, the user's various security parameters can be controlled to maintain the security of the database, these concepts include schemas,

With PHP you can easily connect to the database, request the data and display it in your Web site, or even modify the data in the database. MySQL is a very popular database, and there are many tutorials about PHP and MySQL on the internet. MySQL is

4 scripts are required to perform RAC installation 1) $ORACLE _base/orainventory/orainstroot.sh (performed at end of Clusterware) 2) $CRS _home/root.sh (performed at end of Clusterware) 3) $CRS _home/bin/vipca.sh (the script is automatically

After half a month of Oracle Dataguard physical repository configuration and learning, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. In the process of nearly 10 dataguard configuration, it is

The maximum number of partitions that can be allowed in a table has not been much cared for before. If you don't check the document, is there a quick way to get the results? At that time, manual is 11.2 environment, so first thought of the interval

Case 3: --All of the table space data files are lost, restore data files (open) 1) test environment 07:37:23 sql> INSERT INTO scott.test values (6); 1 row created. 07:39:18 sql> INSERT INTO scott.test values (7); 1 row created. 07:39:20 sql>

It is very important to develop database applications and choose a good database. This article compares SQL Server with Oracle, DB2 three kinds of database from some aspects, provides some reference for you to choose the database. Open SQL Server

Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions. This article describes the data pump on the table to improve the way to

To achieve maximum protection mode, you can first implement the maximum performance mode and then convert to maximum protection mode. One or three modes of protection Maximum performance (maximize performance): This is the Data Guard default

One, about ADO In a database environment based on client/server architecture, data can be accessed through OLE DB interfaces, but it defines low-level COM interfaces that are not only difficult to use, but are not accessible by advanced programming