Oracle

In some scenarios, if there are problems with the host in the RAC environment, such as hardware failure, we need to store the startup database as soon as possible, and restore the business, then we need to migrate the previous RAC environment to the

After the Rman backup and after the backup of the data files, learned that the process of Rman backup ODU, the majority of TRUNCATE TABLE raw data is not properly backed up (why the vast majority, I can not explain), here you can see the Rman Backup

Implementation statement for Oracle Update Data Update Sql>--Create demo tableSql> CREATE TABLE Employee (2 ID VARCHAR2 (4 BYTE) not NULL,3 first_name VARCHAR2 (BYTE),4 last_name VARCHAR2 (BYTE),5 start_date Date,6 end_date Date,7 Salary Number (8,2

1. Group function Usage Rules group functions in MySQL can be used at will in a SELECT statement, but in Oracle if there is a group function in the query, the other column names must be processed by the group function, or the column in the GROUP BY

A. Download Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html below two website source this official download page net. Win 32-bit operating system download address: Http://download.oracle.com/otn/nt/oracle11g/11201

After installing Oracle 10g R2 under CentOS 6.3, you will find that Oracle does not start on its own, which is normal, because installing Oracle under Linux does not start on its own, you have to set the relevant parameters yourself, First, let's

The Oracle tutorial you are looking at is to resolve connectivity issues in the Oracle network architecture. Recently saw a lot of people talk about TNS or database can not log on issues, simply summed up the following document. 　　 First of all,

It would be a hassle to go straight to step b.A.Because this is the blog I wrote after I installed it, so the first step is to uninstall Odtwithodac1120320_32bit1.2.3.4. To complete, close the window.==================================================

Do database migration is an egg pain, do database design, often do not consider the scalability of data architecture, because do database migration is not to do database design people.Before doing such a database migration, the requirements are

The interviewer asked me about Oracle's architecture a few days ago, and let me draw it on a blank sheet of paper. Looking back at that time answer is also good, most of the content is described, hehe, just saw an article on the internet to explain

Date conversion for 1.MYSQL and OracleThere are 2 date formats in MySQL, dates and time,oracle have only one date format.Oracle> Select To_char (sysdate, ' Yyyy-mm-dd ') from dual;Oracle> Select To_char (sysdate, ' Hh24-mi-ss ') from dual;Mysql>

Sometimes the development of the table structure design, is too random to table field is empty, such as ID1=ID2, if the Allowed field is empty, because the Oracle hollow value is not equal to null value, it is possible to get unexpected results.

Database administrator:Different permissions for SYS and system:SYS: the base tables and views of all Oracle data dictionaries are stored in the SYS user, which is critical to the runtime of Oracle and is determined by the databaseown maintenance,

1. Traditional layer by layer data, and Plsql as a separate unit to return to the client, reduce the query, reduce the network transmission of the round trip, funny2.pl/sql statement blocks are divided into two types: naming (subroutines, functions,

Oracle Databases perform unconventional recoveries through Oracle Dul after truncate deletion of a table of data in the absence of a backup1. Preparing the Oracle Dul test EnvironmentSql> Select COUNT (*) from T_xifenfei; COUNT

Learn Oracle Feelingsjust before contacting Oracle database, I saw a story about Oracle system knowledge from the Internet, called "Sid's House". , reading with interest, did not expect that the story is very good, for beginners to understand the

Reprint Please specify source: http://blog.csdn.net/anxpp/article/details/51345074, thank you!This article is for the most basic operations of students who have not used Oracle (whether they have used other databases or not).1. DownloadAddress: http:

SYSTEM. Cursor_block determining current BLOCK in Oracle Forms Using SYSTEM. Cursor_block system variable. The value of the SYSTEM. Cursor_block system variable represents depends on the current navigation unit:If the current navigation unit was the

As one of the first practitioners who introduced MySQL databases to Alibaba, I have been gradually "eroded" by MySQL from Oracle to its peripheral applications ", until the core system is replaced with multiple stages of MySQL. At first, this was an