Database Administrator

Database Administrators familiar with SQL server 2000 know that DTS can import and export data. In fact, we can also use Transact-SQL statements to import and export data. In a Transact-SQL statement, we mainly use the OpenDataSource function and

Incremental backup) Incremental backup is much faster than full backup. During Incremental backup, only files modified after the last full or Incremental Backup are backed up. For this reason, Incremental backup takes only a few minutes of full

Collected and sorted out a perfect installation tutorial for Oracle 10 Gb in CenotOS Linux 5. Share your friends! Author: David Young (e4twood@gmail.com) Last Update: 2008-1-10 System Environment: CentOS Linux 5 Final Oracle Enterprise 10g

To solve the problem of complex balancing, MySql officially launched the MySql Cluster architecture, the following describes the feasibility of five MySql Server clusters in terms of basic conditions, costs, advantages and disadvantages, and

What pl/SQL must understand:1. process, function, trigger is pl/SQL programming2. process, function, and trigger are in Oracle3. pl/SQL is a very powerful database process Language4. process. functions can be called in java programs. ----------------

ORA-28001: the password has expired scott/tiger When Oracle 11 is used today, scott, the default account in sqlplus, is used to log on. An error is reported and cannot be logged on. Solve these problems: 1. The account scott is in the unlocked

Cluster deployment The cache mode of JDG includes Local mode and cluster mode. This project is deployed in multi-node Clustered mode. Data is replicated between subsets of multiple nodes instead of all nodes. Using subset replication can improve

This article will share with you the Problems and Solutions encountered when installing Oracle 11g on Windows 7. First, on the Windows 7 flagship edition, the Oracle 11g prompts the following error when "product-specific precognition condition check:

1.1 symptom description Abnormal power failure: the database data file status changes from ONLINE to RECOVER. The system displays the following information: SQL> select file_name, tablespace_name, online_status from dba_data_files; FILE_NAME --------

All content involving internal structures is abstract, but the structure of things often determines the nature of things. If you want to know mongodb in a more fundamental way, take it easy! Let's talk nonsense and step into the topic: MongoDB is a

The leader said that after oracle was upgraded to 11 GB, it connected to the oracle database, but opened it through plsql. Click the jobs column, and the created jobs list is not displayed, I asked him about his plsql version. He said it was plsql7.1

After the Oracle database has been upgraded to 11 GB recently, some problems have occurred. I began to find some things that need to be summarized. Every time I thought: next time, when I build my own data warehouse, be sure to pay attention to

Oracle databases are usually the first choice for large databases and large enterprises for the stability, high availability, cross-platform and massive database processing. Despite this, many small and medium-sized enterprises still want to taste

As data increases and the innodb Storage engine is compatible with the future, The mysqldump full backup + incremental log backup policy is considered. Using mysqldump provides good support for most mysql storage engines such as myisam and

Generally, we can see that the terms "Index" and "key" are used for exchange, but they are actually different. An index is a physical structure stored in a database. A key is purely a logical concept. The key represents the integrity constraints

Oracle Enterprise Manager (Oracle Enterprise controller (OEM) provides a governance service for the distributed environment through a set of Oracle programs. OEM includes a set of DBA tools, a repository, and a graphical console. The OEM console

To test Oracle 11.2.0.4 + goldengate 11.2, you need to install oracle in both LINUX testing environments,Test Environment Node 1 Machine name: RAC1 source end Test Environment Node 1 Machine name: the directory structure of the two machines on the

I. Tutorial purpose: Mysql also supports semi-synchronous replication in master-slave replication. mysql replication is asynchronous because of poor synchronization performance. After the master database distributes events, you must wait until the

Today I encountered a strange problem: Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifier [@ More @] SQL> conn

Among them, the first is similar to the pattern adopted by MapReduce 1.0, which implements fault tolerance and resource management internally, and the last two are the future development trends, some fault tolerance and resource management are