Oracle

Environment Overview: Good Dataguard, build reference: http://blog.51cto.com/snowhill/1923591Source: db_name:db RACPreparation: DB_NAME:SBDB1 stand-alone1 Enable DGMGRLRelated parameters: Dg_broker_startDg_broker_config_file1

Background: The Oracle database is installed on this computer and is connected using Plsql.After the Oracle 11g database is installed today. Connect to the database with Plsql the dead and alive are not connected. Also, the Database drop-down box

Source: https://www.cnblogs.com/xd502djj/archive/2010/11/16/1878392.htmlWhen you drop a table, deleting the table action causes trigger or constraint to conflict, and the system will receive an error warning message without allowing execution. A

The permission system of Oracle database is divided into System permission and object permission. System permissions (Database system privilege) allow the user to execute a specific set of commands. For example, the CREATE TABLE permission allows a

A stored procedureA stored procedure is a precompiled collection of SQL statements and optional control-flow statements, stored as a single name and processed as a unit. Establishing stored procedures on ORACLE server can be called by multiple

When password file was used for Redo Transport authentication, the password of Redo Transport user should be same across PR Imary and all its physical and snapshot standby databases. By default SYS user was used to authenticate redo transport

Oracle 12c Turn off statistics collection and enable statistics collection--Turn off statistics Col client_name for A60select client_name,status from Dba_autotask_client; Client_name STATUS-------------------------------------------------------

1. Querying all descendant nodes under a node (including parent nodes at all levels)1 // all descendant nodes with a query ID of 101, all levels of parent nodes, including 101 2 Select T.*from +='101'by = Prior ID2. Querying all descendant nodes

I. Overview of SQL　　Origins in the standard no longer repeat, mainly divided into ddl,dml,dclFor an introduction, refer to MySQL section : http://www.cnblogs.com/jiangbei/p/6696202.html　　Objective of this section:by studying this chapter, you will

Common Oracle-developed tools are SQL Developer and PL-Developer, which personally feel that the former is better than the latter, but larger (more than 300M) occupies resources, and the user experience is generally, while the latter is relatively

Description: The system used by the author is a Windows 10 64-bit system, and the software and plugins used are installed based on a 64-bit system.I. Software preparation1.windows 10 64-bit operating system2.NaviCat primium 11 64-bit program

Many online tutorials, but generally older, worried about the new version of the changes, so personally tested, the recording process is as follows:First, the environmentCentos7.3 192.168.56.104Oracle is installed under Windows, 192.168.56.101Second,

Oracle Database PLSQL learning summary, oracleplsqlPLSQL Introduction PLSQL is an extension of SQL99 in Oracle., Basically every database will expand SQL. Oracle's extension to SQL is called PLSQL... What is SQL99? (1)Is the rule for operating all

Oracle bpm workspace cannot view the process instance or the ADF awt component normally. How can this problem be solved ?, Workspaceawt Background: 1. in the process of online migration, encountered in the https://xx.xx.xx.xx: 8001/bpm/workspace

Oracle sorts specific information for a column [decode], oracle sorts decode In ORACLE queries, if there is no sorting, but you want to route the information of a specific value in a column to the front, use the decode (field, 'field value', number)

Explain the table partitions by day, by month, and by year in oracle. Partition Table concept: When the amount of data in a table increases, the speed of data query slows down, and the performance of applications degrades. In this case, you should

Oracle Database exercise example and answer sharing, oracle exercise questions I. Create a table 1. create table empgj (empno number () primary key, ename varchar2 (10), 2.job varchar2 (9), mgr number (), hiredate date, sal number ), comm 3. number

Oracle Database-DML (data operation language), oracle-dml DML: data operation languageNote: In addition, deletion, modification, and query, the query is the most important, the core, and the most gold content.That is to say, this section! ImportantI.

Oracle-date-based Data Query tips, oracle-date Query The date type is a common type for storing date classes in oracle, and its processing is also worth more attention in database usage. For example, you can use the to_char function to convert the

Based on the solution of ORA-19815 flash back space explosion problem, ora-19815 flash back The problem that the flash back area is full is also frequently encountered. The most important thing is that the flash back setting size and archive are