Oracle

The interval partition is actually a special range partition, so it's convenient to convert a range partition table into a interval partition table, and you can also convert a interval partition table to a range partition table. For a normal range

The two concepts that are easily confusing for first-contact Oracle databases are Oracle instances and Oracle databases. These two concepts are different from instances and databases under SQL Sever, and of course there are similarities. Just in SQL

Flash Recovery area space is not enough to cause the database to open or hang to live 1. Problem and resolution process Sql> select status from V$instance; STATUS ------------ Mounted sql> ALTER DATABASE open; ALTER DATABASE Open * Line 1th

First, the concept Tablespace: is a logical collection of one or more data files Table Space Logical Storage objects: Permanent segment--> such as tables and indexes Temporary segment--> such as temporary table data and sorted segments Rollback

In Oracle databases, Undo has three main roles: providing consistent read (consistent read), ROLLBACK TRANSACTION (Rollback Transaction), and instance recovery (Instance Recovery). Consistency reading is relative to dirty read (Dirty read).

Creating triggers The general syntax for creating triggers is: CREATE [OR REPLACE] TRIGGER trigger_name {before | After} {INSERT | DELETE | UPDATE [of column [, Column ...]]} [OR {INSERT | DELETE | UPDATE [of column [, Column ...]]} ...] on

--Logging mode (LOGGING, FORCE LOGGING, nologging) --================================================== First, logging mode (LOGGING, FORCE LOGGING, nologging) 1. Meaning of the three LOGGING: Log information is logged to the online redo log

Reduce disk IO IO for distributed disks 1, the table space using local management, the file spread to different devices 1 separate the data file from the log file 2 Reduce server-independent disk IO 3 Evaluate the use of bare equipment 4)

I. Classification of authority: System permissions: The system requires users to use the database permissions. (System permissions are for users). Entity permissions: The access rights of a user to a table or view of another user. (For a table or

Case 7: --Recovery with incremental backups 1) Establish an incremental backup -------0-level backup using image backup as an incremental backup rman> copy datafile 2 to '/disk1/rman/prod/users_%s.bak '; 2) Establish a level 2 differential

Case 4: --Recover tablespace (open state) 1) test environment 07:47:00 sql> INSERT INTO EMP1 SELECT * from emp where rownum 2 rows created. 07:47:14 sql> commit; Commit complete. 07:47:17 sql> SELECT * from EMP1; EMPNO ename JOB MGR

1) View the database character set 03:12:58 sql> Select Userenv (' language ') from dual; USERENV (' LANGUAGE ') ---------------------------------------------------- American_america. Zhs16gbk 2 Edit Linux Nls_lang variables 03:13:20 sql>!

In the previous article I've talked about using synonyms to connect to Oracle under SQL Server 2005, and we can use synonyms to connect Oracle under SQL Server 2005 to real-time access to Oracle databases. However, if the table data stream in Oracle

Subroutines are named Pl/sql blocks that can accept parameters and are invoked by other programs. There are two types of pl/sql subroutines, procedures, and functions. In layman's terms, a procedure is used to perform an action, and a function is

I. Basic ENVIRONMENTAL requirements System environment: System version: Rhel5u8 x86_64 Oracle Version: Oracle 10.2.1 IP Address ODB1 192.168.100.144 192.168.101.144 ODB2 192.168.100.143 192.168.101.143 Server Shutdown selinux/iptables

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 introduces the improvement of data pump to the table fuzzy

Oracle database transparent Data encryption (TDE), introduced as part of Oracle's Advanced Security options (Version 10.2 and later), selectively enables sensitive database data that remains in the underlying data files of the database and all

In Oracle database systems, There are two ways to authenticate users if they want to log on to an Oracle database as a privileged user (Internal/sysdba/sysoper): Authenticate with an operating system-integrated authentication or a password file that

With the popularization and improvement of the application of computer network, Oracle database application is changing in every field, it has excellent performance and convenient operation, which is one of the most favored in the database system at

The refresh of materialized views is actually not fundamentally different from normal SQL execution, so you can customize the refresh operation by creating triggers on materialized views. Just two days ago, someone asked me on the blog, if you add