Oracle

This paper uses Oracle 11g Dataguard broker Switchover Test 1. Using Dataguard Broker Test switchover 1 Main Library situation Sql> select Open_mode,database_role,db_unique_name from V$database; Open_mode Database_role Db_unique_name -----------

Triggers are a technology provided by many relational database systems. In Oracle systems, triggers are similar to processes and functions, with pl/sql blocks for declaration, execution, and exception handling processes. 1 Trigger Type Triggers

ROWID is a rownum-like pseudo column that locates a relative unique address value for a record in a database. Typically, the value is inserted into the database table when the row data is is determined and unique. For clustered tables, because of

The role switching between Data guard master and subordinate libraries is divided into the following two kinds: 1) Switchover Swithchover are usually artificial and planned for role swaps, such as upgrades. It is usually lossless, that is, there

Client an Oracle suddenly when the machine, because the business start-up, the customer subconscious reboot the server, the system is up, ready to switch to Oracle users to start the database, can not SU switch, it is really to add to the

This article describes two of the most common ways to develop Oracle Applications in Visual C + + 6.0: ADO (ActiveX Data Objects, ActiveX database objects) and OCI (Oracle call Interface, Oracle Invoke Interface). Through the design experiment, two

ORACLE10G has a new feature flashback Database that, when you start it, periodically writes the changed chunks to the log file of the flashback log. Note that these logs are not written by the traditional log Writer (LGWR) procedure, but by a new

CREATE TABLE T0 ( Sid int NOT NULL, Sname VARCHAR2 (20) ) Tablespace test; --Loop Import data Declare MAXRECORDS constant int:=100000; I int: = 1; Begin For I in 1..maxrecords loop Insert into t0 values (i, ' Ocpyang ' | | i); End Loop;

Absrtact: This paper introduces the characteristics of Jcorba and how to deploy the Java CORBA component in Oracle Application server through a Jcorba application example. The rapid development of the Internet has changed the traditional way of

Directory First, sybase12.5 for NT version in the Win2000 platform installation, the interface characters appear garbled problem Second, Sybase after the network share or copy to the local hard disk, still can not install the problem Third, after

Data pump includes export table, export scheme, export table space, export database 4 ways. 1, EXPDP command parameters and instructions (1) ATTACH This option is used to establish an association between a client session and an existing export

Compared to EXPDP, IMPDP and exp, IMP found that the former did not have the Resumable function, the test found that EXPDP and IMPDP automatically used the resumable characteristics C:>EXPDP TEST/TEST@ORCL directory=dir_temp dumpfile=t.dmp tables=t2

A few years ago, when Oracle abandoned the client's forms, one of the built-in functions that disappeared was about passing arguments to the alert message function. If you are dealing with errors or missing input parameters (you should), part of the

The interconnection of different database platform is commonly called the heterogeneous service of database, now each large database can realize such heterogeneous interconnection, but the specific implementation technology of each manufacturer is

I have used personal oracle+developer2000 to develop some programs, when porting to Oracle for NT, I found some features appear error prompts. The study found that the original user was not able to connect normally. Because alias (alias) is not

Oracle databases have always had the ability to audit operation types against the database and to keep audit trails in a system table. This table is named Sys.aud$ and is located in the data directory. In some operating systems, you can also write

Although the previous article introduced the Native_full_outer_join and no_native_full_outer_join two hint, but in fact Native_full_outer_join did not play any role, Because Oracle's optimization of the full outer join makes the new execution plan

The TOPAS command can monitor system activity ――memory,i/o,paging space,cpu,process. This command is included in the Perfagent.tools file set. How to use the command: Topas [D-Number_of_monitored_hot_disks] [-h] [I.

Oracle Emanager Database databases 1. Start OEM Dbconsole [Oracle@rac1 10.2.0]$ emctl start Dbconsole Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, Oracle Corporation. All rights reserved. Http://10.85.10.

There are no exp_full_database roles, and the following error occurs: Ora-31631:privileges are required Ora-39149:cannot link Privileged user to non-privileged user Sql> CREATE DATABASE link Pdbl connect to Rman identified by Rman using ' catalog