Oracle

In the execution plan development process, the transformation and the choice has this different task; in fact, after a query finishes syntax and permission checks, the first step that is called "query transformation" occurs, where a series of query

Login test environment discovers a node listener exception root@xxxxdbb:/#crsctl Status Res-t--------------------------------------------------------------------------------NAME TARGET State SERVER State_details--------------------------------------

Prior to 11.1, many people might have known that Oracle database history passwords could be restored through alter user identified by values password, but several problems occurred in 11g:1. Dba_users no password record (null value), this problem

The decode () function is one of the powerful functions of Oracle Pl/sql, and it is currently available only in Oracle company SQL, and not in the SQL implementations of other database vendors. (But it's not a standard SQL function, but that's his

Oracle database The process of creating temporary tables and the contrast with the different points of the SQL Server Temp table is the main content of this article, let's take a look at this part of the content, we hope to be able to help you. 1.

1.1.1. RMAN-06556 Date: 2014-05-21 16:33 Environment: Test environment "Story description" A whole-library backup was performed using Rman, but an error was encountered while an incomplete restore was made, prompting a data file to recover from

This article supporting the source code download First, the preface At present, many units in the system transformation and upgrading, faced with the development of various independent departments of the application of the database unified to

Oracle Audit Vault and Database Firewall 12.2 new featuresThe backup recovery components of the Audit Vault server are integrated into the AVDF product. When the Audit Vault Agent (audit agent) restarts or AVDF upgrades are received, Audit Trail

First, the advanced level of PL/SQL-control structureIn any computer language (c,java,pascal) there are various control statements (conditional statements, loop structures, sequential control structures ...), and there are also such control

2016-6-12 22:35:51Working for more than a year of Oracle, recently learning MySQL, think carefully about the various connections, feel these concepts are quite annoying! Recently organized a bit, share their own understanding, some things are

Oracle----PL/SQLPL/SQL is a programming language that combines process language (procedural Language) with Structured Query Language (SQL)PL/SQL is unique to Oracle, and is an extension to the. Different database vendors have similar "dialects" that

One, Oracle trace fileThere are three types of Oracle trace files, a background alarm log file that records the activity of the background process during startup, shutdown, and operation of the database, such as tablespace creation, rollback segment

Oracle VM VirtualBox Virtual Machine Export Tutorial | Browse:583 | Updated: 2015-01-31 11:21 1 2 3 4 5 6 7 Step through ReadingSometimes we need to use a system that is loaded

DescriptionRaw: Unprocessed type, can store binary data or byte charactersLong: variable long string data, longest 2g,long has VARCHAR2 column attributes, can store long text in one table up to a long column "not recommended"Long RAW: variable Long

Cross-Library queries are often used when we use SQL Server and Oracle to store data at the same time. To make it easier to use cross-Library queries, one of the best ways to do this is by creating a linked server. You can create a linked server for

A few days ago because of a oracle32bit client + PL/SQL connection not Oracle was the leader despise, asked me to use PL/SQL No, I installed the open PL/SQL login interface is not the same as his, there is no connection for normal, sysdba options ,

The concept of change sets is introduced in conformance CDC. A change set can include several tables that have relationships with each other, such as a primary foreign key reference relationship. The CDC can guarantee data consistency when capturing

How to query Apache server logs using MySQL statements: mysqlapache Linux has a notable feature. Under normal circumstances, you can analyze system logs to understand what is happening in your system or what is happening. Indeed, system logs are the

A customer's database was faulty a few days ago and we needed emergency support. After learning about the environment, I was shocked. The data volume was about 55 TB. First, let's look at the fault information: Fri Mar 25 22:57:10 2016Errors in file/

Oracle 11g launched the new SQL performance Analyze (SQL performance Analyze), which is now widely used in upgrade and migration scenarios. Of course, some other scenarios can also be considered for use, for example (optimizer parameter modification,