Oracle

Principle: Oracle can retrieve data by placing the table at a point in time ( or SCN)before it is deleted, based on the restoration of tablespace information, using data from a restored tablespace, similar to a consistent read method.Prerequisite

First, you need to understand that the physical structure of the database is determined by the operating system files of the database, each Oracle database consists of three types of files: Data files, log files, and control files. The database's

There are two ways to connect Oracle using Sqlplus.First, the Simple waySqlplus username/password @ip or hostname: Port/Database service NameSecond, the way of pre-configuration TNSNamesUnder the "%oracle_home%\network\admin" path, there is a

Oracle goldengate Learning-basic concepts and configurations (1) a    goldengate introduction Oracle Golden Gatesoftware is a log-based structured data replication backup software that parses the sourcedatabase online logs or archive logs

Oracle goldengate Learning-basic concepts and configurations (2)One, Oracle ogg download:Http://www.oracle.com/technetwork/cn/middleware/goldengate/downloads/index.html650) this.width=650; "src="

Oracle nested tables are rarely used, and the following is a look at how they are stored. With an example, a user is responding to a department.Sql> select * from V$version;BANNER-----------------------------------------------------------------------

In Oracle, if the foreign key is not indexed, the modification to the parent table causes the child table to be added to the full table lock. This consists of two cases: 1. Delete rows from the parent table, if there is no index on the foreign key,

Time synchronization between nodes is important for Oracle and is often done by setting up an NTP server before the 11g release. In Oracle 11g, a new CTSS (Cluster time Synchronization Services, cluster synchronization Service) service was added to

>>>>>>>>> Rman_archivelog.bat CD/D D:\app\product\11.2.0\dbhome_1\BINRman Target sys/[email protected] Catalog rman/[email protected] @ ' F:/DELETE.RMN '>>>>>>>>> Execution Script:delete.rmn run{Allocate channel T1 device type disk;Delete noprompt

http://blog.csdn.net/davidhsing/article/details/64087701, if you need to create a global DBLink, you need to first determine the user has the right to create DBLink:SELECT * from User_sys_privs where privilege like upper ('%database link% '); If not,

The previous article covered the full scan, which will describe the structure and scanning of the index, and will begin to describe each of these scanning methods later.An index scan is performed when Oracle retrieves specific column values for one

Oracle uses regular expressions without these 4 functions:1, Regexp_like2, Regexp_substr3, Regexp_instr4, Regexp_replaceLook at the function name and guess what the use is.Regexp_like can only be used for conditional expressions, similar to like,

On Oracle 11g, you can partition on a virtual column, and this feature is useful, and here's a test:Sql> select * from V$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise

First, what is a functionA function:1. is a named PL/SQL block and must return a value2. Can be stored in the database repeatedly executed3. Can be part of an expression or provide a parameter valueII. syntax for creating functionsYou must have at

1. Change the archive pathIn oracle10g, the default archive path is $oracle_base/flash_recovery_area. For this path,Oracle has a limitation that only 2G of space is available to the archive log by default, and you can use the following two SQL

People who often write SQL statements should know that the main use of the group BY statement is to do subtotals, the following is one of its most common use methods (according to Department, the position of the respective statistical

The index and index of the partition technologyAbout Partitioning technology-Index  I. Partition Index classification: Local prefix partition index) Global partition Index) Local non-Prefix partition index (localnon-prefixed partitioned index) 1.1

Database downtime migration oracle10g instance1. Operation 1.1 of the original database view original configuration 1.1.1 view User Permissions View user system permissions: SQL> select * from user_sys_privs; View User Roles SQL> select * from

Mybatis batch inserts a large number of oracle data records. Performance Problem Solving Environment: mybatis + oracle11g r2 1. Use "direct path insertion" ("/* + append_values */" in the following SQL statement), and use the keyword "union all ":

ORA-01552: non-system tablespace & #39; xxxx & #39; do not use system rollback segments ORA-01552: non-system tablespace 'xxxx 'cannot use system rollback segmentsFault analysis:The UNDO tablespace data file is damaged, causing the update operation