Database Administrator

The following method is a general summary of the massive data processing methods. Of course, these methods may not completely cover all the problems, however, such methods can basically deal with the vast majority of problems encountered. The

In Oracle RAC, in addition to the TAF Method Based on the client, there is also the TAF Method Based on the server. You can regard the TAF method of the server as an upgraded version of the TAF method of the client. The TAF of the server must be

When installing Oracle 11g RAC, We need to configure the ntp service. There are many ways to configure the clock synchronization mode when using virtual machines. You can use the clock synchronization feature provided by vmware or directly use a

Case when is convenient when different conditions require different return values. It can be used when assigning values to variables or in select query statements. (Exit immediately if one meets the requirement) -- Search format, NO content after

When a report is displayed in Cognos, the "no available data" is displayed because there is no data. So I want to use an image instead. There is a "no data content" in the chart attribute. After clicking "open", there are three options: 650)

--********************** -- Use of DBVERIFY --********************** Oracle cannot be identified in Oracle format or its contents are damaged due to hardware faults or operating system faults during Oracle database operation. Fault, which can be

An SQL example that causes a deadlock is provided.Deadlock definition: in a broad sense, it includes the operating system application database. If two Process sessions hold each other's resources, they always wait for the other to release. This

The general paging method is like the following:The so-called "three-layer nesting" Statement), SELECT *   FROM   (SELECT a.*                 ,rownum rn           FROM   (SELECT * FROM table_name) a           WHERE  rownum  WHERE  rn >

ORACLE common error: ORA-00845: MEMORY_TARGET not supported on this system 1. Question proposal The following error is reported: [oracle@night ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 25 15:39:40 2013Copyright (c) 1982,

Application of Regular Expressions in ms SQL Server the Oracle database provides regular expressions by default. For details, see wikipedia. For example: REGEXP_LIKE (), REGEXP_INSTR (), REGEXP_SUBSTR (), REGEXP_REPLACE (), which is not directly

Yesterday, I want to migrate the database on my machine to a dedicated server. The local Oracle10g is installed, and the database installed on the server is Oracle9i. I will first perform the following operations: export the database file locally:

1 DB2 Programming 1.1 do not use the TAB key after creating a stored procedure Create procedureYou can only use spaces, but not tab keys, otherwise the compilation will fail.Remember, remember. 1.2 use temporary tables Note that temporary tables can

The data types and sizes in database storage vary. In some cases, only the numeric type is stored, and some only the text type is stored. Many databases support various specialized types: Date and Time, binary character, and Boolean. Matching data

SQL Server 2000 provides some XML functions, which are used to convert the XML documents in the component layer of the relational row set through XML, read XML documents, and load data in batches. For example, you can pass an XML document to a

10 Gb databases can use more new optimizer hints to control optimization behavior. Now let's quickly parse these powerful new hints: 1. spread_min_analysis With this hint, you can ignore the Compilation Time Optimization rules for workbooks such as

The method functions are provided below:1. Declare an external function to obtain the temporary path of the system. FUNCTION ulong GetTempPath (ulong nBufferLength, ref string lpBuffer) LIBRARY "kernel32.dll" alias for "GetTempPathA"2. Core

There is often a need to operate databases on the Internet to unify similar database applications across cities across the country. The data changes on one node are not only reflected locally, but also to the remote end. The replication technology

ASP + Access security hazards ASP + Access the main security hazards of the solution come from the security of the Access database, followed by security vulnerabilities in the ASP Web page design process.1. storage risks of Access databases In the

When you Access 2000 using DAO, will the following error message be displayed? "Run-time error 3343 Unrecognized Database Format XXX" There are two ways to solve this error: 1. If you use Data Control to connect to the database of Access 2000:

We often receive calls from customers. My database logs are full. Is there any way to quickly clear them? Especially for some beginner DB2 users to maintain a large data volume system, this is almost a problem they will inevitably encounter. We