oca 11g

We have previously introduced the virtual columns and read-only tables in the new Oracle 11g feature. Today we will introduce another new feature, the combined trigger. In earlier versions of Oracle, you can use the FOLLOWS keyword to control the trigger execution sequence. For example: 01 CREATE OR REPLACE TRIGGER XXX_TRG 02 BEFORE INSERT 03 ON XXX_TABLE_NAME 04 REFERENCING NEW AS NE

Flashback is based on the content in the undo segment. Therefore, due to the undo_retenton parameter, to use the flashback feature, you must enable automatic tablespace revocation. Oracle flashback data archive (FDA) is a new feature in Oracle11g. By storing changed data to another created flashback archive ), different from undo, you can set a separate storage policy so that it can return to the old data before the specified time without affecting the undo policy. In Oracle

In general, Oracle 11g R2 RAC provides the following features: High Availability: shared-everything mode ensures that services are not stopped when a single node fails, and other nodes in the cluster will take over quickly Scalability: multiple nodes share the load and can provide processing capabilities far beyond that of a single database. Addition and deletion of nodes can be completed online without downtime Ease of use: multiple databases ca

The focus of this article is "Join clause (join_clause)", rather than table join itself. Content The table and its data used in this article Oracle 11g R1 (11.1) join clause (join_clause) Inner Joins) Cross-join) Outer Join (Outer Joins) Natural Joins) References The table and its data used in this article Department table DEPT Employee table EMP Oracle 11g R1 (11.1) join clause (join_clau

Environment: Oracle 11g R2 + SQLPlus Problem: Oracle SQL Import Solution: Win + Run -------> Cmd -------> enter the following command: -- Syntax: sqlplus user name/password @ SQL File Sqlplus system/manager @ H: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ RDBMS \ ADMIN \ scott. SQL Note: scott under H: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ RDBMS \ ADMIN. the SQL file records the table and data of the SQL user. Importing this file is equiva

If the prompt says no... /oracle/11g/Solaris/j2ee/oc4j_applications/applications/em. ear file. After downloading the Oracle 11g, decompress the package and there are two folders. This error occurs because the file copy is incomplete, you only need to merge the database \ stage \ Components in the second part with the database \ stage \ Components in the first part, and then install the component. If this

Oracle Clusterware 11g 2nd and later versions. For Oracle 11g 2nd and later versions, password-free SSH is required. This command writes the DSA public key ~ /. Ssh/id_dsa.pub file to write the private key ~ /. Ssh/id_dsa file. Do not distribute the private key to any user who has no permission to install the Oracle software. Repeat steps 1st to 4th for all other nodes (bkjia2) that use the DSA key that yo

In the Oracle 11g environment, you can use utl_smtp to create a storage process for sending mails, 11gutl_smtp If there are too many email storage processes on the internet, I will not forward them. Let's make a simple example; Create or replace procedure Send_mail (mail_body varchar2) is smtp_conn utl_smtp.connection; user_name varchar2 (20): = encrypt ('username @ email.com '); user_paswd varchar2 (20): = encode (utl_encode.base64_encode (utl_raw.c

In Oracle11g, you can easily locate the current trace file, that is, access the view v $ diag_info.Store @ TEST> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0-ProductionNLSRTL Version 11.2.0.1.0-ProductionStore @ TEST> set l

database (DBCA) Some people say: It turns out that there was a problem with node consistency, but all my checks passed. **************************************** ************************************ [Root @ rac1 ~] #/Opt/app/grid/root. shRunning Oracle 11g root. sh script... The following environment variables are set: ORACLE_OWNER = grid ORACLE_HOME =/opt/app/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome

Friends who use Oracle 11G may have struggled with this problem. The data exported by the exp command may be inexplicably missing some tables, during the analysis, we will find that these tables are empty tables with no records inserted. The cause is that oracle 11g introduces a new feature. When the new table is not inserted, the server does not create a segment for this table by default to save storage sp

Oracle 11g realbench 2 (11.2.0.1) reports an error when exporting an empty table. After checking the cause, it turns out that an optimization was made in this version. During table creation, no storage space is allocated. The storage space is allocated only when data is inserted for the first time. This saves a lot of storage space when there are many empty tables in the system. However, if the system only has a small amount of space, it is unnecessar

This article describes the process of installing Oracle 11g on RHEL 6.3. You can download RHEL from many image sites, such as Oracle 11g, note that the version 11.2.0.3 is used in this article. Currently, this version is not available for download only for paid accounts, if you need this version, you can contact me by email, readers can download the published version, download 1, download 2. When installing