Oracle

I. Preparations ◆ 1. Download oracle 9i for linux ◆ 2. Download patches P3006854_9204_LINUX.zip before running runInstaller. (The extracted name is rhel3_pre_install.sh) ◆ 3. Modify the kernel parameters (you don't need to modify the kernel

The following code has been tested and can be run directly.A brief description of Oracle analysis functions, multidimensional functions, and Model functions, mainly for BI report statistics, not necessarily comprehensive, but a few instructions on

This article will discuss and share with you some common classic queries of oracle SQL. You are welcome to add them. You can also share some classic queries. In this article, if you think there is any better solution to every problem, you are

Here we will introduce several steps to manually create a database in Oracle, including preparation and implementation.AD:Manual database creation in Oracle is the focus of this Article. We hope this article will help you better use Oracle. In

  Rails connection to Oracle Database Preparations: 1) install ActiveRecord Oracle adapter     Sudo gem install activerecord-oracle-adapter -- source http://gems.rubyonrails. org2) install Oracle

  Use of oracle Wallet (that is, internal Encryption technology TDE (Transparent Data Encryption )) 1. TDE is a new feature introduced in Oracle10gR2. Ensure that the Oracle version is 10gR2 or later. -- View the oracle version: Select * from v $

  Oracle is the world's leading information management software developer and is well known for its complex relational database products. This article introduces the Oracle optimizer, which is a very useful tool. Before executing an SQL statement,

DataGuard is a database-level HA solution provided by oracle. Its primary functions include redundancy, data protection, and fault recovery. Of course, depending on the configuration, data guard can also have the following features: high

Oracle has its own file structure, Buffer structure, process structure, and its own optimization functions.The Oracle server consists of an Oracle database and an Oracle instance. That is to say, our Oracle database is only a collection of data

Purpose:The merge command can be used to modify or insert data from one table to another. The insert or modify operation depends on the conditions of the on clause. This statement can be executed in two steps in the same statement, which can reduce

Today, due to business needs, we ran EXP conditional export and found some differences between WINDOWS and LINUX. The main difference lies in sensitive characters. The example is as follows:LINUX:Exp us/pass TABLES = \ (t_ec_event \) file =/tmp/test.

1. Case StudyWhen the database is started, an error is returned:[Oracle @ localhost ~] $ Sqlplus "/as sysdba"SQL * Plus: Release 10.2.0.1.0-Production on Mon Sep 19 19:31:05 2011Copyright (c) 1982,200 5, Oracle. All rights reserved.Connected to an

Manage common Oracle data dictionaries and dynamic performance views 1.v$ version query database version information [sql] select * from v$version; [html] BANNER --------------------------------------------------------------------------------

Oracle 11g R2 RAC: Configure DNS resolution scan vip Oracle 11gR2Grid Infrastructure (CRS) introduces Single Client Access Name (SCAN) to simplify Client Access to database services. This article will introduce in detail how to configure DNS to

In Oracle, When you modify the table name, you encounter ORA-00054: the resource is busy, but specify to get the resource in NOWAIT mode, or timeout is invalid. Solve Oracle 11g to modify the table name: Rename ASSETPORJECT to ASSETPROJECT;

Setting the sga_target non-normal value causes the ORA-00093 to solve the problem of setting the sga_target non-normal value causes the ORA-00093 to install a new oracle server and then modify the parameters. SQL> alter system set sga_target = 1320

Oracle-RMAN backup (2) in Oracle RMAN backup (1), the backup of various files in RMAN is described. backup sets are replicated in RMAN backups. You can back up your own backups. That is, you can back up a file in multiple directories. oralce

ORA-1157 and ORA-01110 error practices often encounter related ORA-1157OR1110 errors in the backup experiment, related error information, nothing more than data files, log files, and control files and a series of related file problems, in general,

Log switch gap and resolvable gap appear in the SWITCHOVER master database. One example is switchover today. The environment is 11.2.0.3 + OEL5.7. At the beginning, the status of the master and slave databases is normal and the direct SWITCH

Relational Database Standardization Theory & functional dependency and paradigm theory the relational model can be formally represented as R (U, D, dom, F); U: Attribute Set, D: indicates the attribute domain, dom: ing set of attributes like domains.